Excel not updating when figures are changed
 

Spreadsheet set up for capacity planning. However when I change the number
of staff, the formula's behind the cells are not immediately updating the
results. Results are only updated after I have saved the spreadsheet. What
could be the cause of this?

Hi
Maybe Excel is set to Manual Calculation. Have a look at
Tools/Options/Calculation tab and make sure it's set to Automatic

--
Andy.


"karenb" wrote in message
...
Spreadsheet set up for capacity planning. However when I change the
number
of staff, the formula's behind the cells are not immediately updating the
results. Results are only updated after I have saved the spreadsheet.
What
could be the cause of this?