Excel 2007 works really slow on Vista
Hello Everyone,
I'm having problem working on Microsoft Excel 2007. I have installed Windows Vista on my system. I use excel to analyze thousands of data points from a data acquisition device, and when I do a simple x vs y scatter plot, excel 2007 cannot handle this, and it takes at least 10 minutes to respond. I required Excel frequently to work on, and this type of problem i can't handle it anymore.:angry: So i just uninstall Microsoft Office 2007 and had install Microsoft 2003 and its working absolutely fine on Windows Vista. Can any one tell me that why Microsoft Office 2007 works so slow on windows vista? Any kind of information related to this issue would be appreciated.
Thanks.
Re: Excel 2007 works really slow on Vista
Hey even i was facing the same problem when i used to open few worksheets with graphs. Excel often stops responding for tens of minutes. XY (scatter) plots on large data sets cause the most problems. When you Select two columns with more than 30k lines each, it creates a scatter plot and Excel starts falling of the tracks. After creating the plot, it takes ten or more minutes just to select and delete the graph again.
I'm really frustrated by how much Excel 2007 irritates.:wub: Excel 2003 could only import the first 30k lines from a CSV file, but after that it could create, resize or refresh X-Y plots virtually instantaneously. With Excel 2007, I can import 1M data points and calculating formulas happens in a reasonable time, but if you want to plot it, it takes anywhere from 10x to 10000x longer than Excel 2003.:crybaby:
Re: Excel 2007 works really slow on Vista
Graphics do not appear as expected in an Excel 2007 workbook.
1) You experience slow performance in Excel 2007. This issue occurs if the following conditions are true:
* A chart contains lots of data points.
* The value (y) axis is fixed.
2) When you convert a Microsoft Office Excel 2003 workbook that contains complex charts, Excel 2007 may stop responding.