Restrict recalculation
Using the VBE (Alt+F11) you can modify the properties (Press F4 if its not
already visible) of each indivudal sheet to allow/disallow calculations for
that sheet. However, you can not disable calculation on a cell by cell basis.
Due note that if your calculated sheet refers to a noncalculating sheet,
your results will not be real-time accurate.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Allizex" wrote:
I want to stop some, but not all, of the cells in a workbook from
recalculating. Is this possible
--
Allizex
|