calculations do not update unless page is saved

[Barry A&P]

I have an excel 2003 workbook with 32 tabs the first set of tabs are named
according to the date 09-01-09 the last two tabs total all the important info
one is 1st - 15th other is 16th - 30th on my total pages the first column
is the date 09-01-09 (as Text) and i use the indirect function in my formulas
to refer to the individual tab names.. everything works and calculates but
it doesnt happen On-the-fly like excel usually does i have to actually hit
save for any calculations to update even on the individual tabbed dates
formulas like A1+A2 dont display a result untill saved.. did i go wrong
somewhere or is this just something that happens with INDIRECT??

Thanks for your help

Barry

 

[Pete_UK]

It sounds like your file is set for Manual calculation - you can press
F9 to recalculate.

Alternatively, set it to Automatic Calculation by clicking on Tools |
Options | Calculation Tab then Automatic and OK. Save the file so that
it will open in that mode next time.

Hope this helps.

Pete