Update Excel Chart object on an Access Form

[lowflight9]

Help!

I have an Excel 97 Chart displayed in an Access 97 form. The data is linked and updates the Excel Sheet fine but I can't get it to display the updated version of the chart on my form.

Can anyone help me with how to achieve this.

Thanks!

 

[ploeryan]

Hello,

I have a word picture linked as an unbound object frame then to update the code is as follows:

'set update to manual
Me.Picture.UpdateOptions = acOLEUpdateManual
'manually update picture
Me.Picture.Action = acOLEUpdate

Me.Requery

Hope this helps.

 

[lowflight9]

Thanks!

I've tried this in several formats but still get errors such as "Can't Access" the execl file. I'm assuming this is due to it being linked. I alo get a run time error 2750 Ole Opertion Failed.

 

[ploeryan]

Hello

How is your excel chart linked?

I have just created an excel chart in excel and paste special paste link excel chart into an access form.
Make sure that the chart is enabled and not locked and the above code should work unless the excel is not closed.

 

[lowflight9]

OK the problem is I think.

I am updating and Excel link table in the mdb from which has the linked Excel Chart from the same Excel Workbook.

I think that it appears as Read-Only since it's linked.

Is their a way to still get it to work as I need to see the chart change on screen in the form.

J

 

[lowflight9]

Hi!

Does anyone else have any ideas on this. I just keep getting the Message "Cannot Access Chart.XLS" when it does the update.