Thread: How do I stop formulas from calculating when I open a worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
  
Posts: 389
Default How do I stop formulas from calculating when I open a worksheet

Navigate to [Tools] then [Options] then [Calculation] tab. Click "Manual".

If you want this equivalent in code:

Application.Calculation = xlCalculationManual

to reset:

Application.Calculation = xlCalculationAutomatic

HTH


"J. Caplan" wrote:

I have a worksheet that calls several user defined functions. Every time I
open up the file in Excel, I have to wait while it recalculates every cell
with a formula.

How do I prevent this from occurring on startup?
Reply With QuoteReply With Quote