Excel not updating formulas

February 9, 2010 at 04:50:39
Specs: Windows Vista
I have a spreadsheet where four tabs feed data into the first as a summary page. However, when changing values on the tabs the formulae values on the summary tab isn't updating. To update the formula value you have to manually go into the cell and enter out of it, anybody know a solution to this?

See More: Excel not updating formulas

Report •

February 9, 2010 at 05:12:42

Do you have calculate set to manual, rather than automatic.

Not sure what version of Excel you are using.
In Excel 2003 goto Menu-Tools-Options
Then select the Calculation Tab, and make sure that Automatic is selected in the Calculation section.

In Excel 2007 you get to this through the Office button, then Excel options at the bottom.
Then click the Formulas tab on the left.


Report •

February 9, 2010 at 06:59:28
Thanks for your response, calculate is set to automatic. I'm a little puzzled as it's a spreadsheet we use daily and this has only just started occurring..

Report •

Related Solutions

Ask Question