View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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.