Excel 2007Chart updating problem
Interesting, sounds like all open workbooks get fully re-calculated when
that linked (to scrollbar) cell is changed.
For curiosity could you try this - with your big file open, in the small
test file compare changing the "linked" cell with the scrollbar (just one
increment) and by manually changing the linked cell similarly. This would
confirm it's a recalc issue rather than anything to do with leaving the
mouse down on the scrollbar.
Regards,
Peter T
"Robert Avery" wrote in message
...
Ok. You are right that m graph is based off of a lot of calculations
(a 2.5MB excel file). I had also made a test workbook to see if it
was just the size of my workbook (which works perfectly speedy until
Excel 2003), but I left the 2.5MB file open when testing it on the
simple file. Merely having the other workbook open was enough to slow
the redraw of the simple graph on a separate workbook to a crawl -
closing it fixed the problem. Nevertheless, the fact that Excel 2007
can only handle really tiny graphs in this manner, a severe downgrade
from 2003, is definitely a problem for me. Is MSFT going to resolve
any of these speed issues in an upcoming service pack? Because it is
really slow.
Thanks for your help, Peter.
|