Powerpoint update data excel

Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen.

Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! In the Paste Special dialog box, select the Paste Link radio button and the dialog box will look like the following:.

The table comes on to the PowerPoint slide looking like a picture type object and can be sized by dragging the corner white circle resizing handles. Drag the corner handles to make the table as large as you want it to be. You can also drag the entire table to a new position by dragging the center of the table object.

Now, any time the data is updated in the Excel spreadsheet, when the PowerPoint file is opened, the new data will be retrieved and displayed if the system asks you whether to Update the linked data, always select the option that allows the data to be updated with the latest information. If you want to edit the data in Excel, you can double click on the table object on the PowerPoint slide and the Excel spreadsheet will open.

If you want to prevent others from changing the data in the Excel spreadsheet, make the Excel file a read-only file. If you want to send the file to someone else or take the file to another computer to present it, the program will ask if you want to update the links when you open the file, but in this case you will select the option to use the current data since the source spreadsheet file is not available. You will still be able to see the data table, it will contain the current data only and not any updates since you last opened it on your machine where the Excel file is available.

If you want a full video course on the different approaches and methods for using Excel data in a PowerPoint presentation, check out my After the Analysis e-course. Dave Paradi has over twenty-two years of experience delivering customized training workshops to help business professionals improve their presentations. He has written ten books and over articles on the topic of effective presentations and his ideas have appeared in publications around the world.

His articles and videos on virtual presenting have been viewed over 1. His focus is on helping corporate professionals visually communicate the messages in their data so they don't overwhelm and confuse executives.

Skip to content You probably arrived at this page because you are a business professional who has to present regularly to management or executives on analysis you have done in Excel. If so, your link may cause you problems. Will others need to make updates to the table or graph in PowerPoint? If so, they may get frustrated when they get an error message that the source file is not accessible. Does your organization care about branding?

Luckily this is not something that we need to worry about as PowerPoint and Excel play nicely together, allowing us to create dynamic data in our PowerPoint slides. Open Excel and highlight the cells that contain the data you wish to link into your PowerPoint slides. Home Tutorials Downloads. The are many occasions where we need to display data from Excel into our PowerPoint slides.