Hi,
I am able to link an excel graph to powerpoint using copy and paste+special. When I do this, the graph I copied automatically updates to corresponding changes made in excel. However, when I save both files and exit them, the link breaks? After re-opening both files, the update feature doesn't work properly. I have to manually update the link by right clicking the graph (in the powerpoint slide) and selecting update link.
Is there a way to automatically update the linked data between excel and powerpoint without having to do it manually?
Will the update work when powerpoint is in presentation mode?