View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Very slow graphs in Excel 2007

Thanks, Jerry. I was in fact alluding to your results when I said that the
hotfix will improve performance but not bring it up to accustomed standards.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
To put numbers to what Jon has said: in pre-hotfix copy of Excel 2007 I
had
one package take 10 to 11 times as long to generate some charts as it took
under 2003 (running on a slower machine, even). With the Hotfix applied,
the
improvement was such that it only took about 8 times as long in 2007 as in
2003.

Actually, it may have been worse than that, depending on how you look at
it. The application had to read in almost 500,000 data points from a text
file and put them into worksheets. That took about 1m35s on both
machines.
In Excel 2003 at that point, the generation of 50+ graphs from the data
was
virtually instantaneous. But in 2007, the generation of the same graphs
initially took 10 to 11 minutes (pre Hotfix), and about 8 minutes (after
hotfix applied).

"Jesperfect" wrote:

How come the updating of graphs is runing so much slower in Excel 2007?

I am having a xy-graph with two data series each containing approx.
17,000
values. When I change the data it takes several seconds to update the
graph
where I am used to instant updates.