Slidewise will tell you if your Charts have Excel files embedded behind them and how large they are, however, it will not tell you if there is anything sensitive in them - that you have to find out manually.
Two common reasons for removing embedded Excel data are:
- Reduce file size
- Remove sensitive data from your file before sharing
Open Slidewise and expand the Embedded chart data heading. The first thing to look out for is the size of the XLSX files. If they are small, then there is little chance that they contain lots of extra data like in the example shown below.
However, if you have XLSX files that are many MBs, it's unlikely all that data is just for the chart. The files in the example below are much larger and contain multiple tabs of data that isn't visible in the presentation. It can still be accessed by anyone with the file however.
Note: You may notice that the size of each Excel file is the same. This is because there are multiple charts pasted in from the same large source spreadsheet and the whole XLSX file has been embedded for each chart.
Remove Excel data from charts
The Remove Data option in Slidewise will strip the Excel file away leaving just the chart. You can still format it like a chart, but you will no longer be able to edit the data. Right-click on the Embedded chart data heading, or any individual Excel file to access the remove options.
Check the Excel data
If you're not sure what's in the Excel files you can check the files easily using Slidewise. Right-click on an Excel node and select Edit Data in Excel. This will open the Excel file behind the chart on the tab that the chart comes from so that you can investigate.
We recommend that you look at what is on the other tabs to decide if it is a problem to share. If there is something problematic, then you have a few options.
You can remove any tabs or cells that aren't needed for the chart, although you'll need to make sure your chart isn't referencing data on the other tabs. Then just close the Excel file, which will prompt it to update in PowerPoint.
Make sure you check for hidden tabs, in case the data you want to avoid sharing is on a hidden tab. Simply right-click on any tab in the Excel file and if the Unhide slide option is available then click on it to make them visible for checking.
Check the charts
To view any of the charts in PowerPoint, simply right-click and select Show in PowerPoint to jump straight to it.
How to remove embedded excel from PowerPoint
A note on file size
If you mostly want to reduce the size of the Excel files embedded within your presentation, then the option above of removing data using Slidewise is one approach.
However, if it isn't working then you may need to extract the Excel file and do some more fine grained investigation. Click the Edit Data in Excel option and then Save As... from Excel. We recommend following the steps outlined in our guide to why Excel files get so big and what you can do about it.
Once you've fixed the file size, you can replace the chart in your presentation from your now smaller Excel file and delete the bloated version.
Check it out at www.neuxpower.com/slidewise.