Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exclude cells from calculation?
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()? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exclude cells from calculation?
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 -- Regards, Tom Ogilvy "Claude" wrote in message ... 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()? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude Cell from Calculation | Excel Discussion (Misc queries) | |||
How do I set up a calculation to exclude weekends? | Excel Worksheet Functions | |||
Date Calculation to exclude weekends | Excel Worksheet Functions | |||
Exclude non-numeric data from calculation | Excel Worksheet Functions | |||
calculation to exclude weekends | Excel Worksheet Functions |