Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
loss of speed with excell 2007
My previous spreadsheet developed with excel 2000 is very fast compared to a
very slow 2007. the file is over 100 meg with a lot of formulas, pivot tables. plotting is extremely slow with 07 and excessively slow when opening/closing grouped rows or using filters. Although I've turned off background error checks and even auto calculations it still appears there's a lot of recalclations going on in the background with 2007. xcel 2000 doesn't do this and is very fast. I don't know what to try next...helpppp-- halfpint |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
loss of speed with excell 2007
I must be the luckiest XL 2007 user in the world because I see these posts
constantly and have never experienced performance degradation on my workbooks. In any event, here's an informative white paper about Excel 2007 performance: http://msdn2.microsoft.com/en-us/library/aa730921.aspx Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "halfpint" wrote: My previous spreadsheet developed with excel 2000 is very fast compared to a very slow 2007. the file is over 100 meg with a lot of formulas, pivot tables. plotting is extremely slow with 07 and excessively slow when opening/closing grouped rows or using filters. Although I've turned off background error checks and even auto calculations it still appears there's a lot of recalclations going on in the background with 2007. xcel 2000 doesn't do this and is very fast. I don't know what to try next...helpppp-- halfpint |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
loss of speed with excell 2007
Luck- a major factor in the end user experience with any Microsoft product.
"Dave F" wrote: I must be the luckiest XL 2007 user in the world because I see these posts constantly and have never experienced performance degradation on my workbooks. In any event, here's an informative white paper about Excel 2007 performance: http://msdn2.microsoft.com/en-us/library/aa730921.aspx Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "halfpint" wrote: My previous spreadsheet developed with excel 2000 is very fast compared to a very slow 2007. the file is over 100 meg with a lot of formulas, pivot tables. plotting is extremely slow with 07 and excessively slow when opening/closing grouped rows or using filters. Although I've turned off background error checks and even auto calculations it still appears there's a lot of recalclations going on in the background with 2007. xcel 2000 doesn't do this and is very fast. I don't know what to try next...helpppp-- halfpint |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
loss of speed with excell 2007
thanks for the white paper, it gave some ideas but it hasn't solved the
problem. It states that with 2007 some formulas are volatile, they recalculate even though you're using manual. does anyone know how to turn this feature off on 2007. I'm really disappointed with the speed and the filter functions of 2007 -- halfpint "halfpint" wrote: My previous spreadsheet developed with excel 2000 is very fast compared to a very slow 2007. the file is over 100 meg with a lot of formulas, pivot tables. plotting is extremely slow with 07 and excessively slow when opening/closing grouped rows or using filters. Although I've turned off background error checks and even auto calculations it still appears there's a lot of recalclations going on in the background with 2007. xcel 2000 doesn't do this and is very fast. I don't know what to try next...helpppp-- halfpint |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
loss of speed with excell 2007
Current performance of Excel 2007 under WinXP 2GB Ram 1.8Ghz cpu
vs Excel 2003 under Vista 2GB ram 1.8 Ghz cpu In both cases I had the file on my desktop and no other programs were running Open the file by dble click Excel 07 22 sec Excel 03 11 sec including click on warning to enable macros Change the value of a single cell to 566 Worksheet FID IRS Cell G12 Excel 03 <1 sec Excel 07 Gave up after two minutes. Attempted to close Excell which caused crash of program "Dave F" wrote: I must be the luckiest XL 2007 user in the world because I see these posts constantly and have never experienced performance degradation on my workbooks. In any event, here's an informative white paper about Excel 2007 performance: http://msdn2.microsoft.com/en-us/library/aa730921.aspx Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "halfpint" wrote: My previous spreadsheet developed with excel 2000 is very fast compared to a very slow 2007. the file is over 100 meg with a lot of formulas, pivot tables. plotting is extremely slow with 07 and excessively slow when opening/closing grouped rows or using filters. Although I've turned off background error checks and even auto calculations it still appears there's a lot of recalclations going on in the background with 2007. xcel 2000 doesn't do this and is very fast. I don't know what to try next...helpppp-- halfpint |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 VBA-XLL macro speed slow | Excel Discussion (Misc queries) | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
Excell 2007???? | Charts and Charting in Excel | |||
Speed fill function for MS Ecel 2007 (Beta) | Excel Worksheet Functions | |||
Weight loss line chart to monitor weight loss progress | Charts and Charting in Excel |