Updating links in powerpoint
I have pasted (paste special, paste link) data a cell in Excel into PPT.I update the excel data and simultaneously I can see the data change in the PPT slide (edit mode) However, when I run the PPT slideshow: Does anyone know if it's possible to have a live link within the PPT slideshow? [MSOffice 2010 on Win7] VBA can probably help, but I'm not a VBA programmer...This procedure is very helpful if you have financial data, performance figures or other data that may be prepared and approved by a compliance area and changes monthly or quarterly.It allows the latest data to be shown in the linked Power Point slides, making sure that the presentations are compliant with regulations that require updated data to be presented to clients.You can also get a free ebook on How to Present your Excel data effectively to Executives.If you create and deliver financial presentations, check out my Kindle ebook "20 Tips for Effective Financial Presentation with Power Point" and this slideshare presentation.This article shows you the step by step procedure for importing linked data from an Excel spreadsheet into a Power Point slide (works in Power Point 2003, 2007, 2010, 2013, 2016).
I think this may be for an earlier version of PPT, so it might not work for you, but it would be a great place to start.
On the Home ribbon, click the Copy button to copy the data table to the Windows Clipboard. Step 4: Paste the Table on Your Power Point slide On the Home ribbon, click the arrow below the Paste icon to bring up a sub-menu and click on Paste Special.
In the Paste Special dialog box, select the Paste Link radio button and the dialog box will look like the following: Click the OK button to insert the table.
If you have Power Point slides that report regularly updated financial or numeric data that comes from an Excel spreadsheet, you can save a lot of time by linking the data instead of retyping it.
This technique also allows you to secure the data from others changing it and prevents accidental transposition errors.