Linked Excel Graphs in Access

G

Geof W

I have created some charts in excel that are generated
form exporting data in excel. When the Data is exported
into excel the Graph, in excel is automatically updated.

I have created an Unbound Object Frame in a from that is
linked to the excel chart. The database has mulitple
users. when I open the Unbound Object Frame Form the graph
is automatically updated to the current data that I
exported. When another from a different PC exports data
and opens the form the Object(Graph) is not updated. If
they double click on the Unbound Object Graph it will open
up excel and the chart is correct. If they then close out
of excel the chart is correct in the Access Form. Once
they close out of the form and try to get back into it the
chart is incorrect again. For some reason Access is not
automatically updating the excel chart on the form for
other users and PC's. Please Help!!
 

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

Embed the same Excel multiple times 0
Month of year in code 2
Form with a graph - problems with the title of the graph 0
Linking data in MS Word into Excel 5
Graph not showing 3
Editing source data for linked Excel/PPT graphs 0
Exporting Data from Excel into Power Point 1
Excel 2007 charts: want to avoid zero values 1

Top