View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karen53 Karen53 is offline
external usenet poster
 
Posts: 333
Default Main page Recalculations

Hi,

I have a 'Main Page' which contains cells linked to and from various
individual worksheets. I had some trouble with volatile functions. I found
them and removed them. The workbook worked great...Until I performed a file
save as.

Then all Worksheet calculation code for all pages runs everytime a change is
made to 'Main Page', even to an empty cell that is not linked to anything.
If I save the workbook, close it and reopen it, it reverts to working
correctly. Then if I change an unlinked cell nothing happens.

If I make a change to a cell that should trigger the other worksheet
calculates, they run as they should...but they don't stop running. Again, if
I make a change to an empty unlinked cell all the code runs, until I again
save the workbook, close it and reopen it. Then it works correctly again.

Does anyone have any suggestions?
--
Thanks for your help.
Karen53