Disable auto-update

  • Thread starter Thread starter Jamal
  • Start date Start date
J

Jamal

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open, Update, and Close files automatically 5
hide multiple worksheets based on a formula value in one cell 1
Auto Copy Data from one worksheet to another 1
preventing referencing hidden cell 3
calculation 2
Auto-Filter 2
Auto Update a sheet through Macro 4
Reference Separate Sheet for Formula 2

Back
Top