Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default Updating formulas

You could make sure that Tools?OptionsCalculation is set to Automatic.

To refresh you can hit F9 or CTRL + F9


Gord Dibben MS Excel MVP

On Thu, 30 Mar 2006 15:52:17 -0600, craftcenter
wrote:


Can I create a button to refresh all the formulas. The IF statements
don't update when new information is input.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas Not Updating!!! carlyman Excel Discussion (Misc queries) 3 September 22nd 05 11:42 PM
Formulas not updating until save DKY Excel Worksheet Functions 3 September 9th 05 02:41 PM
Printing Excel Formulas without file paths updating Kim Excel Discussion (Misc queries) 0 August 18th 05 04:55 PM
Inserting Columns and Formulas updating Jaime Balance Sheet Excel Worksheet Functions 1 May 2nd 05 02:02 PM
duplicating formulas without updating Wazooli Excel Worksheet Functions 3 December 16th 04 04:27 PM


All times are GMT +1. The time now is 09:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"