Updating links between excel and powerpoint

Posted by / 27-Feb-2020 14:42

When you use this feature, the presentation changes automatically each time your workbook changes. Once the links are created in the presentation, you may need to update them at a future point.

If the Excel file is not open it is possible to update links using the following methods.

You can use Power Point’s basic table formatting tools on it, but you can’t use any of Excel’s features after the conversion.

There are a couple of ways to do this, depending on whether or not you want to maintain a connection with the source Excel sheet. You actually have three options for including a spreadsheet in a Power Point presentation.Both are pretty similar, in that you end up inserting an actual Excel spreadsheet in your target presentation.It will look like an Excel sheet, and you can use Excel’s tools to manipulate it.If you the Excel data, you can edit it directly in Power Point.Double-click anywhere in the spreadsheet and you’ll stay in the same Power Point window, but the Power Point Ribbon gets replaced by the Excel Ribbon and you can access all the Excel functionality. And when you want to stop editing the spreadsheet and go back to your Power Point controls, just click anywhere outside the spreadsheet.

updating links between excel and powerpoint-15updating links between excel and powerpoint-37updating links between excel and powerpoint-71

On Home tab of the Ribbon, click the down arrow beneath the “Paste” button, and then choose the “Paste Special” command from the dropdown menu. And it’s here where you’ll find the only functional different in the processes of linking or embedding a file. Whichever option you choose, you’ll next select the “Microsoft Excel Worksheet Object” in the box to the right, and then click the “OK” button.