Exclude cells from calculation?

C

Claude

Hi all

Is there a way to exclude certain cells in a worksheet
from calculation when f9 is hit? I have cells referencing
to an external data source which result in errors when f9
is hit and the data source is not available.
Is it possible to stop calculation from occuring with
Workbook_SheetCalculate() or Worksheet_Calculate()?
 
T

Tom Ogilvy

No, there isn't a way to stop individual cells from calculating. You could
possibly write a macro that calculates on specific cells and use that
instead of F9.

You might look at Charles Williams' site. He has done a lot of research on
how excel calculates

http://www.decisionmodels.com
 
Top