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
"Timmy Mac1" wrote
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...o&userid=15188
| View this thread: http://www.excelforum.com/showthread...hreadid=492996
|