linking problem

[wayne]

I posted this yesterday but got no responses in the gettingstarted
newsgroup. I could really use some help!!!

In my application I press a button on a form to transfer the results of a
query to an excel spreadsheet that contains macros to manipulate the data
and produce a graph. When the transfer process is completed I am returned
to my form. At that time I press a button to preview an Access report that
has the excel chart ilinked into the detail section.
The first time I run the process everything works fine. When I select
another item to transfer to excel, the process updates the excel spreadsheet
but does not update the chart on the report. What I get is the previous
chart, but with the current heading in the report header. If I go to design
view and click on the chart and immediately go back to preview it updates
the chart. How can I get it to update without manual intervention.

Thanks in advance for any help with this.
Wayne