I've tried several thisngs but I can't get my Linked Chart to update. Now I get this message "Cannot Access Chart.xls"
Me.OLEUnbound1.UpdateOptions = acOLEUpdateManual
Me.OLEUnbound1.Action = acOLEUpdate
Any idea's
I'm trying to get the chart to update on my form.
The data...
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
I have an Excel document that I'm using to update a Chart that is on an Access Form.
I've tried several methods to get the chart to update without success. It looks like the Excel Chart is read-only and wont let me do this. Any suggestions would be great.
Thanks!
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.
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!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.