Chart not updating (Recently moved to Excel XP)

  • Thread starter Thread starter Mark Matzke
  • Start date Start date
M

Mark Matzke

Since we upgraded to Microsoft Excel we have had a problem
with miscelanious graphs not updating. I have gone to
options and checked automatic update correctly, and still
the problem contiues. For this email I am focusing on one
of my more important graphs.

Background: 1) We recently converted the office from
Excel 97 to Excel XP, worked great before the upgrade.
2) The graph is pulling from hidden sheets that have data
imported to it from an Access 97 database. 3) The graph
that is not updating includes bars and lines.

Any help you might be able to provide would be GREATLY
appreciated!

-Mark
 
...."I have gone to
options and checked automatic update correctly,...."

Just checking - on this dialogue box
[TOOLS/OPTIONS/CALCULATION] have you ticked the option
that is labelled "UPDATE REMOTE REFERENCES" as well as
selecting "AUTOMATIC" option in the CALCULATE options?

Mardi Caulfield
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In Excel 2007 chart with multiple lines, mouse doesn't track lines 1
print excel graph 1
Problems with Viewing Charts in Excel 2007 1
Why is the graph invisible when I move it to a "new sheet"? 1
Excel graphs change when pasted into Publisher - Metafiles change? 0
Totals in the data table but not in the graph / chart 1
Excel charting label assistance (Sydney Australia) 3
Excel 2007 - Printing graphs with no data or graph lines 1

Back
Top