Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 clocks -- Excel 2003 works fine.
I developed a pretty complex workbook (20 worksheets, between 500 and 2000
rows per sheet, columns A to CZ), 95% of the formulae are arrayed {}. The workbook has multiple switches, dropdown select menus, quite a number of SUMPRODUCTs, OFFSETs, limited INDIRECT functions, the workbook has range names for every input (cell/row). The complete workbook takes 25 seconds to calculate in Excel 2003 (1.2 GHz Pentium M), if you change all switches at once. Excel 2000 takes forever for the exact calculation, even when I don't change a single input, it sometimes takes 45 seconds, and freezes in 80% of the times. The very first calculation (F9) after I open the file usually works fine. I'd highly appreciate some advice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xls file works fine in Excel 2000 and 2007 but crashes on opening in 2003 | Excel Discussion (Misc queries) | |||
Visual Basic Function works fine in Excell 2003 but not in Excel 2 | Excel Discussion (Misc queries) | |||
Object works in Excel 2000 but not in 2003 | Excel Programming | |||
Pivot table is not valid in Excel 2000 but works fine in EXCEL 200 | Excel Discussion (Misc queries) | |||
Macro works fine in xl2002 but does not in xl 2000 | Excel Programming |