Recalculation Problem After Save As.
Do you change the file type or filename extension to something other than .xls?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Stuart Hagon" wrote in message ...
| Hi
|
| I hope someone can help me I have a bit of an odd issue with Excel.
|
| I have an Excel worksheet that contains a number of calculations which works
| fine until you use save as to make a copy by calling it another name. After
| this is done the calculations in the worksheet no longer recalculate when a
| value in the calculation is changed.
|
| I have Excel 2003 SP3 running on a Windows XP sp2. I have also check to make
| sure that the automatic radial button is checked on the calculation tab of
| the options panel.
|
| Thanks
|
|