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

Well, there are some effects, although I don't know about this one.

If you have a large worksheet, like a 40 year financial projection with one
row per month, and you split the window to be able to see the start line
together with the bottom line, it takes almost
twice as long to calculate as without the split.
It seems as if Excel thinks it has to format all the rows for display
instead of just one screeenful.

--
Kind regards,

Niek Otten

"Jim Rech" wrote in message
...
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
|