View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel Bonallack
 
Posts: n/a
Default Stop calculating on open

I have a large file which I open frequently, and it drives me crazy if I
forget to turn off automatic calculation, as it can take 10 minutes to
calculate - I usually crash out of Excel to stop it.

I added code to switch calculation to manual as the workbook opens, but
unfortunately, that workbook_open procedure seems to fire after the workbook
has been through the calculation process. Is there any code that runs
immediately when a file is opened?

Thanks in advance
Daniel