| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable auto-update
I have a workbook consisting of many sheets. One sheet contains complex
formulas linked to data in other sheets, which takes a while to recalculate everytime I enter data in another sheet. This slows down the typing to snail speed. Is there a way to prevent auto update on this particular sheet? I need formulas in other sheets to update automatically. Could this be done by a maco? Any help greatly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable auto-update
Depends on what version of excel you're using.
I think that this was added in xl2002, but you can test it pretty simply: worksheets("sheet1").EnableCalculation = false From the immediate window in the VBE. Jamal wrote: I have a workbook consisting of many sheets. One sheet contains complex formulas linked to data in other sheets, which takes a while to recalculate everytime I enter data in another sheet. This slows down the typing to snail speed. Is there a way to prevent auto update on this particular sheet? I need formulas in other sheets to update automatically. Could this be done by a maco? Any help greatly appreciated. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to disable the pop up for enable auto update? | Excel Discussion (Misc queries) | |||
| Sometimes formuli in workbook don't auto update with auto-recal on | Excel Worksheet Functions | |||
| Can I disable auto formula update? | New Users to Excel | |||
| how to update data on sheet1 and have it auto update on sheet2 | Excel Programming | |||
| excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Linear Mode
