Powerpoint embedded excel not updating
I am getting a run-time error'438' Object doesn't support this property or method on the paste function.' Open Weekly File Set xl App = Create Object("Excel. I've searched the web pretty thoroughly for a solution and come up dry.
Unfortunately as soon as I switch the category, the copy-pasted chart updates in Power Point.The following options are then provided: In order for a document to be updated, Q needs to know that you wish to export to that document.This is done via the steps described in Changing the document being exported to.And if the workbook contains information you don't want to reveal, this is NOT the way to go.
On the plus side: since all the charts are embedded, you don't have to worry about links to external files breaking or put up with MS' silly warning messages and slow updates to links every time you open the file.
I was able to overcome this issue previously by using a virtual machine and running Excel in said virtual machine.