View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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
|