Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
grouping rows
Hello,
In Excel 2002 if you had lots of groups of rows in a sheet. When you expanded/shrunk them, it would be done immediately. Moving to Excel 2003, this process was slowed down. Almost to a crawl. The thought around my office here, was it was done on purpose. To show the end user the expansion. Is there a way to make it run faster? Like in the 2002 version? is there a 2003 setting for this? thanks |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
grouping rows
=subtotal() was enhanced in xl2003. It now provides a way to ignore rows that
are hidden -- not just by data|Filter|autofilter. (the 100 series parms like =subtotal(10x,...)) But with that enhancement, xl2003 thinks that it should recalculate each time you hide/unhide rows. Maybe you could turn calculation to manual (Tools|Calculation tab), then do what you want. Remember to recalc or go back to automatic recalc before you trust the results of any formula. greg wrote: Hello, In Excel 2002 if you had lots of groups of rows in a sheet. When you expanded/shrunk them, it would be done immediately. Moving to Excel 2003, this process was slowed down. Almost to a crawl. The thought around my office here, was it was done on purpose. To show the end user the expansion. Is there a way to make it run faster? Like in the 2002 version? is there a 2003 setting for this? thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
grouping rows
yes,
turning off calc does make it faster. thanks "Dave Peterson" wrote in message ... =subtotal() was enhanced in xl2003. It now provides a way to ignore rows that are hidden -- not just by data|Filter|autofilter. (the 100 series parms like =subtotal(10x,...)) But with that enhancement, xl2003 thinks that it should recalculate each time you hide/unhide rows. Maybe you could turn calculation to manual (Tools|Calculation tab), then do what you want. Remember to recalc or go back to automatic recalc before you trust the results of any formula. greg wrote: Hello, In Excel 2002 if you had lots of groups of rows in a sheet. When you expanded/shrunk them, it would be done immediately. Moving to Excel 2003, this process was slowed down. Almost to a crawl. The thought around my office here, was it was done on purpose. To show the end user the expansion. Is there a way to make it run faster? Like in the 2002 version? is there a 2003 setting for this? thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grouping rows | Excel Discussion (Misc queries) | |||
grouping rows... | New Users to Excel | |||
Grouping Rows | Excel Discussion (Misc queries) | |||
Grouping Rows | Excel Programming | |||
Grouping rows together | Excel Worksheet Functions |