Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | | | | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding and unhiding sheets | Excel Discussion (Misc queries) | |||
Locking Sheets / Hiding Sheets | Excel Worksheet Functions | |||
Hiding Sheets | Setting up and Configuration of Excel | |||
Protection and Hiding Sheets | Excel Discussion (Misc queries) | |||
Hiding Sheets | Excel Worksheet Functions |