LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Time needed for the group function: big diff between Excel2003 and Excel2000

HI

We are experimenting a consistant difference in real time behavior between
Excel 2003 behaviour and Excel 2000 behaviour in front of the Group
function...

Using the exact same Excel file that have around 1000 lines with several
level of grouping, the time needed to group under level 1 or 2 is around 2
to 3 seconds with Excel 2000 while it is around 25 to 30 seconds with Excel
2003. In both case the same function is quite immediat if we settle the
calculation mode to manual...

The same phenomenon can be seen if you ask for the group function on a file
without any formulas while another big excel file with a lot of formulas is
open at the same time but not active...

Is there something different than the calculation mode that should be
settled in Excel 2003 in order to get the same response time on group
function than in Excel 200? Any other information, experience about that
problem? Is it link to a different behavior of excel in front of calculation
strategy?

Thanks for your help
Alain79


 
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
Opening .csv file in Excel2003 vs Excel2000 Holmark Excel Discussion (Misc queries) 9 April 24th 07 07:43 PM
How can I use autosave from excel2000 in excel2003 Claude J Johnson CPA Australia Excel Worksheet Functions 14 November 28th 06 06:50 PM
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM
excel2000 owc doesn't work on excel2003 ! help! Excel Discussion (Misc queries) 0 January 21st 05 08:29 AM
Can't open Excel2003 workbook containing VBA macros with Excel2000. Paul S. Natanson Excel Programming 2 June 18th 04 03:57 PM


All times are GMT +1. The time now is 11:13 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"