Automatic updating of excel tables in powerpoint slides malthe dating

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.AKA: Everything You Were Afraid To Ask Brian Reilly About Excel Charts, But That's OK, 'Cause He's Gonna Tell You Anyway.When data in Excel changes, you can either update the charts on command or have think-cell do the update automatically.

The other gotcha, which is kind of a given, is that I want the ppt to update to latest excel data when it is opened.I've gotten around this by creating a simple Auto_Close macro in Excel that sets the zoom factor back to 100% and saves and closes the file.Then the charts don't resize in PPT when the links are updated.Unfortunately as soon as I switch the category, the copy-pasted chart updates in Power Point.I was able to overcome this issue previously by using a virtual machine and running Excel in said virtual machine.

Search for automatic updating of excel tables in powerpoint slides:

automatic updating of excel tables in powerpoint slides-56

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “automatic updating of excel tables in powerpoint slides”