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
 
Back
Top