View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Timmy Mac1
 
Posts: n/a
Default Hiding sheets - Impact on Speed


I've goneback to working on a spreadsheet recently where I had several
sheets hidden. After unhiding some of these I noticed that the
calculation (on automatic) was a lot slower after doing this.

I'm surprised that this has such an impact. Does anyone know if it
actually is a feature of excel?

also, is there anyway of releasing all hidden sheets in one go or can
it only be done one by one?

many thanks

tm


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=492996