Excel chart as ole object in access form doesn't update properly

Question

I have an access form where I have included an excel chart as an unbound ole object. (MS Graphs in access are so terrible!) The excel sheet is an independent file, outside the database. Through a DoCmd.TransferSpreadsheet instruction I can export the results of a query to the excel sheet. The graph in excel updates itself, but no change appears in the form, and I don't know how to force the update. I have tried to update the object with the .requery statement, but it does not update. If I manually open the object from the form it does.

Any way to force the update immediately after doing the export?

Thank you very much

Answer 1

Well, it seems i've found some kind of solution to this. I've created a bounded frame to the excel chart. Once the base data of the chart is updated, just setting the focus in the frame through VBA updates the chart. It's the same as one-clicking the frame. This works only for bounded frames. It doesn't work for unbounded frame, in spite of linking it to the excel file.

I don't understand why, but it works for me.

Thanks everyone.