Hi Niek

No all that is being changed is the name of the file for example book1.xls
to book2.xls

Thanks

"Niek Otten" wrote:

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
|