I am trying to make a chart that in Excel 2003 takes no time at all to
display. It can involve up to 20 different series (maybe 500pts each). I
end up editing specific series to a common color, and I turn labels and lines
on or off depending upon consecutive data. Again, Excel 2003 took this with
no problems and showed the edits quickly. Excel 2007 locks up!! It can take
5 minutes for the color palette to show up!!

A known problem. We await MS's solution.
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"JMacC" wrote in message
...
I am trying to make a chart that in Excel 2003 takes no time at all to
display. It can involve up to 20 different series (maybe 500pts each). I
end up editing specific series to a common color, and I turn labels and
lines
on or off depending upon consecutive data. Again, Excel 2003 took this
with
no problems and showed the edits quickly. Excel 2007 locks up!! It can
take
5 minutes for the color palette to show up!!

Wait until Excel 2009 - it will take several days to do!

"JMacC" wrote in message
...
I am trying to make a chart that in Excel 2003 takes no time at all to
display. It can involve up to 20 different series (maybe 500pts each). I
end up editing specific series to a common color, and I turn labels and
lines
on or off depending upon consecutive data. Again, Excel 2003 took this
with
no problems and showed the edits quickly. Excel 2007 locks up!! It can
take
5 minutes for the color palette to show up!!

I found the solution in an earlier post. Follow the link provided below.
Worked well.

Subject: Excel 2007 is SLOW in responding 9/17/2007 7:51 PM PST

By: Jon Peltier In: microsoft.public.excel.charting


Any idea when MS will issue a fix for this?

Probably in Excel 2010. There's a hotfix that improves the performance of
Excel 2007 from excruciatingly slow to painfully slow:

http://support.microsoft.com/kb/938538

Contact MS service, and they'll send you an email (no charge) with a link to
download the hotfix.

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

How effective did you find the hotfix in solving your problem?

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


"JMacC" wrote in message
...
I found the solution in an earlier post. Follow the link provided below.
Worked well.

Subject: Excel 2007 is SLOW in responding 9/17/2007 7:51 PM PST

By: Jon Peltier In: microsoft.public.excel.charting


Any idea when MS will issue a fix for this?

Probably in Excel 2010. There's a hotfix that improves the performance of
Excel 2007 from excruciatingly slow to painfully slow:

http://support.microsoft.com/kb/938538

Contact MS service, and they'll send you an email (no charge) with a link
to
download the hotfix.

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