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

Hiding sheets - Impact on Speed
 

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
|

Hiding sheets - Impact on Speed
 

< 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
|

Hiding sheets - Impact on Speed
 

This used to be the case in older versions of Excel; I can't remember which
ones.

With Excel 2003 I cannot reproduce this effect.

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
< 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
|

Hiding sheets - Impact on Speed
 

This used to be the case in older versions of Excel; I can't remember
which
ones.

I don't doubt it, Niek. It makes sense in a way that what you've seen could
happen. It's less clear to me how worksheet tabs being visible as in the
OP's case would affect performance but anything is possible.

--
Jim
"Niek Otten" wrote in message
...
| This used to be the case in older versions of Excel; I can't remember
which
| ones.
|
| With Excel 2003 I cannot reproduce this effect.
|
| --
| Kind regards,
|
| Niek Otten
|
| "Niek Otten" wrote in message
| ...
| < 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
| |
|
|
|
|
|
|