| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recalculation on hiding rows in Excel 2003
Hi!
I'm having the issue described in KB918621 where hiding rows in Excel 2003 causes a recalculation of the entire worksheet. Since my spreadsheet contains 1500 rows and nearly 840 subtotals, this takes close to 20 minutes... I could use the suggested workaround of disabling automatic calculation but this is a bit extreme. The only alternative I can think about is to set up macros to turn this feature on and off and link them to toolbar buttons. Can anyone think of anything better? Thanks in advance for any help you can offer. Best wishes, Andrew |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| does excel 2003 support more than 65k rows? | Excel Discussion (Misc queries) | |||
| How can I add additional rows beyond the 65,536 in excel 2003 | Excel Worksheet Functions | |||
| Excel 2003 - Protecting and Hiding Columns | Excel Discussion (Misc queries) | |||
| Excell VS Office | Excel Discussion (Misc queries) | |||
| how do I unhide Excel 2003 spreadsheet rows with usual method. | Excel Discussion (Misc queries) | |||
Threaded Mode
