View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.misc
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default EXCEL 2007 VERY SLOW WITH LARGE DATA CHARTS

i can tell you that performance is a big emphasis in 2010. i've submitted a few
examples they're using in their test suite.

download the beta and give it a shot.

--


Gary Keramidas
Excel 2003


"for east" wrote in message
...
I am experiencing similar problem. The Excel is frustratingly sloww on
editing data series. Each of my data series is about 1200 points long
and it is just a pain for the excel to open the dialog to let the data
series be formated, not to mention if I want to change color or
anything about it. I had intended to include about 18 lines in one
chart. It is not a way to go. Right now there is 9 of them and it
seems to be over every limit of the Excel.

:(.

I am bit surprised, I needed this time to work with Excel, for I need
to share my data with some colleges abroad, usually I am working with
another program (Sigmaplot) and I never realized it could take any
computer time to calculate such plots, not to mention, the calculating
program would have problem to just respond.

In the end right now Excel even fails to open the dialog, after five
attempts i did, the particular data series simply drops off the effort
to have the dialog be opened. The CPU time usage drops to zero like if
my command would fulfilled, but the dialog is nowhere (this is after
about 5 min of CPU laborious attempts).

Just frustrating program