Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Extremely Slow
I have a file that should work fine, but is incredibly slow to navigate in
2007. It takes over 30 seconds to just open a row group and running some macros that require calculations on slows it down from seconds to minutes. I am going to try it in Excel 2003 on an old computer as well to see if 2003 to 2007 is the issue, but any help or suggestions are appreciated. Description of file... Laptop is HP 8730W 3 GHz 3GB RAM Windows XP Professional Version 2002 SP2 ~4MB in size Excel 2007 now but originated in 2003 Primary Worksheet = about 4000 rows and only about 64 columns There is quite a bit of conditional formatting and formatting in general but nothing Excel 2003 couldn't handle. A few offset functions but these are disabled in an IF statement A few IRR calcuations that returned #NUM or DIV#0 but these have been disabled via IF statement (If(Iserror(....)) I used to have a short macro that worked in the background if the sheet changed, but that is turned off now as well. There are no data tables or pivot tables in the sheet. Therefore changing to automatic calcs without tables won't help. Is there any way to dedicate more resources to Excel or find out where exactly Excel is bogging down???? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Extremely Slow
Hi,
There are innumerable ways to speed up macros including Application.ScreenUpdating = False Application.Calculation = xlCalculationManual remember to turn the second one back on when the code is finished. The use of large numbers of volatile functions can slow down Excel, as well as lots of graphics. Graphics are more of an issue in 2007 because the graphic quality is so much greater. To handle graphics you need a powerful graphics card, not just a fast computer. The following functions are volatile RAND(), NOW(), TODAY() OFFSET(), CELL(), INDIRECT(), INFO() CELL() -- If this helps, please click the Yes button. Cheers, Shane Devenshire "KMH" wrote: I have a file that should work fine, but is incredibly slow to navigate in 2007. It takes over 30 seconds to just open a row group and running some macros that require calculations on slows it down from seconds to minutes. I am going to try it in Excel 2003 on an old computer as well to see if 2003 to 2007 is the issue, but any help or suggestions are appreciated. Description of file... Laptop is HP 8730W 3 GHz 3GB RAM Windows XP Professional Version 2002 SP2 ~4MB in size Excel 2007 now but originated in 2003 Primary Worksheet = about 4000 rows and only about 64 columns There is quite a bit of conditional formatting and formatting in general but nothing Excel 2003 couldn't handle. A few offset functions but these are disabled in an IF statement A few IRR calcuations that returned #NUM or DIV#0 but these have been disabled via IF statement (If(Iserror(....)) I used to have a short macro that worked in the background if the sheet changed, but that is turned off now as well. There are no data tables or pivot tables in the sheet. Therefore changing to automatic calcs without tables won't help. Is there any way to dedicate more resources to Excel or find out where exactly Excel is bogging down???? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel macro in 2007 runs extremely slow | Excel Discussion (Misc queries) | |||
Extremely slow subtotals in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel extremely slow opening | Setting up and Configuration of Excel | |||
Excel and Word EXTREMELY slow to open | Excel Discussion (Misc queries) | |||
Excel extremely slow opening and using | Excel Discussion (Misc queries) |