Hi
Many thanks for the suggestion. I have tried that but it did not seem to
make any significant difference (I inserted the row just above the data,
between the data and the row containing series names).
I have now also experimented a bit further with this particular workbook. I
restored my system to an older state, form an old system image, using Office
2007 SP1, and could manipulate the sheet and the graphs etc to my heart's
content without any problem. Then I installed Office 2007 SP2 on that system
and bang - the response time went completely up the spout with many periods
of inactivity and short term ".... is not responding...". I have also tried
to recreate the graphs and workbook from scratch, and have tried on a few
other machines running Office 2007 SP2 and the [problem remains so this would
definitely appear top be an issue with SP2....
I am now seriously considering ditching 2007 all together if I can find my
old Office CDs...
Thanks again and best wishes, Boris.


"iranuc" wrote:

Try inserting a blank row just above the data. I had the same problem but
with as many as 48000 rows and this seems to wotk.

"Boris" wrote:

Hi, I am having a really difficult time with Excel 2007 sp2... I have some
quite modest charts (line charts with a date category axis or scatter charts)
with two (or more) series (each with perhaps 4000 data points) plotted
against two y axes (with limits manually set). The workbooks containing these
charts just go crazy, becoming unresponsive for 10's of minutes before
updating or allowing any changes to be made (or even allowing me to copy the
charts). This is very reminiscent of an issue with Excel 2007 sp1, which was
fixed with a special hotfix (available only on request). Has this issue
reappeared with sp2? If so, is a similar fix available? This is really
driving me bananas... (and I have to say that I have so far failed to see the
significant improvements I was anticipating from sp2...).
Any help or suggestions would be most gratefully received.
Best wishes, Boris