Excel and Power Point are often used together at companies to produce Financial reports, Audit Reports, Due Diligence Reports, Pitch Books, Investment Memorandum, Portfolio Reviews, etc.
Sometimes, you want to include the data on an Excel spreadsheet in a Microsoft Power Point presentation.
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.
Start by opening both the Excel worksheet and the Power Point presentation you want to edit at the same time.
In Excel, select the cells you want to link or embed.
I am successful in creating the Hyperlinking and obtaining the desired results, however after I save the Power Point file, it deletes the tab and named range that were included in the Hyperlink.
If you regularly create Power Point presentations that include information from Excel, you will know how frustrating it can be.
One disadvantage is that the original spreadsheet file needs to stay in the same location. And since it relies on the link to the original spreadsheet, it’s not so useful if you need to distribute the presentation to people who don’t have access to that location.
Embedding that data, on the other hand, increases the size of presentation, because all that Excel data is actually embedded into the Power Point file.
When opening a presentation, Power Point will ask if you wish to update the links. The Links window will open, which provides you with various options to update, edit and break links.
If you link Excel files to Power Point presentations often, you will soon find it doesn’t always behave how you might expect.
There are some distinct advantages to embedding, though.