partially turning off auto calculate?

[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)

 

[Chip Pearson]

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)