Hiding sheets - Impact on Speed

T

Timmy Mac1

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
 
J

Jim Rech

I've never heard of the visible state of worksheets affecting calc speed.

You need a macro to unhide worksheets all at once:

Sub UnhideSheets()
Dim WS As Worksheet
For Each WS In Worksheets
WS.Visible = xlSheetVisible
Next
End Sub


--
Jim
in message |
| 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?action=getinfo&userid=15188
| View this thread: http://www.excelforum.com/showthread.php?threadid=492996
|
 
Top