Why is excel 2007 slow when selecting chart data from the formula
 

Excel 2007 is very slow when selecting chart data from the formula bar. For
example 8, X-Y scatter graph curves are generated from data base of
approximately 2000 lines long x 2 columns. A convienient way to edit the cell
references for each curve is to simply click onto a curve and the cell
references will appear in the formula bar. With all earlier versions of excel
including 2003, once the curve is clicked the cell reference appears in the
formula bar almost instantaneously. However when the same method is used with
excel 2007, it can take 10-20 seconds before the formular appears.

Why is excel 2007 slow when selecting chart data from the formula
 

This is a known problem. Hopefully, this is one that SR1 will address. In
the meantime there is a hotfix which is described at
http://support.microsoft.com/kb/938538
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"RodMTS" wrote in message
...
Excel 2007 is very slow when selecting chart data from the formula bar.
For
example 8, X-Y scatter graph curves are generated from data base of
approximately 2000 lines long x 2 columns. A convienient way to edit the
cell
references for each curve is to simply click onto a curve and the cell
references will appear in the formula bar. With all earlier versions of
excel
including 2003, once the curve is clicked the cell reference appears in
the
formula bar almost instantaneously. However when the same method is used
with
excel 2007, it can take 10-20 seconds before the formular appears.