Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
on your main page click on the worksheet name and be taken to it | Excel Worksheet Functions | |||
Main Page Button In excel | Excel Programming | |||
display main column on next page | Excel Discussion (Misc queries) | |||
Return to Main Page | Excel Programming | |||
how do I merge total from many pages into one main page in excel? | Excel Discussion (Misc queries) |