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?

Hi, 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.Regards

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..

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History