Automatic updating of excel tables in powerpoint slides
Then, I found the article called provides the steps to copy an excel spreadsheet (from within Excel) and, using the Paste Special function, paste a link to the spreadsheet.By doing it this way, I can now choose to update the file every time it opens.One caution is that if you move the spreadsheet to a new location or if you rename it, it will break the links. However, if you are careful with file placement, this can help for trainings that use spreadsheets with data that could change quite a bit.
The ability to automatically update Power Point slides with new data can save time, money, error, and your sanity.
Some analysis software packages allow your reporting to go into cruise control with clever automation, so you can just focus on the dashboard and wheel.
Automatic updating of excel tables in powerpoint slides comments