Excel worksheets will not recalculate a

R

Robert

I have Excel 2003 running on XP. Some worksheets will not automatically
recalculate, but will only update when I press Save. I undertake a function
weekly, and use a blank worksheet which is renamed each week. However, it is
only some weeks where the auto recalc does not work. I have checked
knowledge base etc with no help available. This problem also occurs on some
other worksheets - all created in Office 2003.
 
N

Norman Jones

Hi Robert,

Try:

Tools | Options | Calculation | verify that the automatic option is
selected.
 
Top