LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding and unhiding sheets D.Hay Excel Discussion (Misc queries) 2 December 10th 05 03:59 PM
Locking Sheets / Hiding Sheets Lee Harris Excel Worksheet Functions 4 November 29th 05 07:21 AM
Hiding Sheets Kim Setting up and Configuration of Excel 3 May 3rd 05 10:45 AM
Protection and Hiding Sheets JudithJubilee Excel Discussion (Misc queries) 4 March 4th 05 02:16 PM
Hiding Sheets Rain Excel Worksheet Functions 10 January 18th 05 08:11 PM


All times are GMT +1. The time now is 10:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"