View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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