Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Slow Grouping of Rows

My client has a workbook that includes one worksheet with 148 rows and 60
columns. There are four levels of grouping for the columns and three for the
rows. That's probably something that the client insists on. Moving from
level 4 to level 1 for the columns is instantaneous. Moving from level 3 to
level 2 or from level 2 to level 3 takes perhaps three seconds. Moving from
level 3 or level 2 to level 1 takes approximately 45 seconds. The
calculation reaches 100% in about two seconds, so I don't think that it's a
calculation problem. What else should I be looking at?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
grouping rows AFE Excel Discussion (Misc queries) 1 February 13th 08 12:19 AM
grouping rows... kang New Users to Excel 5 June 10th 07 05:44 PM
D-sum and Grouping slow down problem Ben Excel Worksheet Functions 2 April 26th 07 03:58 PM
Grouping Rows Moz Excel Discussion (Misc queries) 0 July 21st 06 05:33 AM
Slow grouping and ungrouping since update Bruce H Excel Discussion (Misc queries) 0 June 1st 05 03:37 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"