View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dh13134 dh13134 is offline
external usenet poster
 
Posts: 20
Default Can I calculate a single page ONLY?

Can I calculate a single sheet only, and disable calculation update on other
sheets? I have several sheets that take a few seconds (too long, in my case)
to re-calculate where I'm running a macro that plugs a value into a cell and
gets an answer, plugs another value in and gets an answer, etc. I'd like to
calculate only the sheet where where the calculations are actually being
affected-I'm not concerned with the other sheets.

Thanks
DH