partially turning off auto calculate?

  • Thread starter Thread starter dnickelson
  • Start date Start date
D

dnickelson

Any way to NOT auto caluculate 1 particular formula, while leaving the
rest of excel to auto calculate? In particular, I have an SQL query I
would prefer to run manually, while not interferring with the rest of
my workbook(s)
 
Calculation is an all or nothing setting. You can't prevent calculation of
specific ranges.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top