View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Prevent calculation on open

Try to set Calculation to Manual before opening this workbook
(ToolsOptionsCalculation tab)!

Regards,
Stefi


littlefb ezt *rta:

Is there a way to prevent calculations from running when opening a file? I
can't get the file to open at all because the calculations take hours and
hours. I need to prevent them from running as I open the file.