Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening .csv file in Excel2003 vs Excel2000 | Excel Discussion (Misc queries) | |||
How can I use autosave from excel2000 in excel2003 | Excel Worksheet Functions | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
excel2000 owc doesn't work on excel2003 ! | Excel Discussion (Misc queries) | |||
Can't open Excel2003 workbook containing VBA macros with Excel2000. | Excel Programming |