Disable Edit Data for Embedded Charts in Word and PowerPoint
Question details
Prevent viewers from accessing an Excel chart's source workbook through Edit Data in Word or PowerPoint.

- Product
- Microsoft Word 2013, PowerPoint 2013, and Excel 2013
- Device & OS
- not provided
- Scenario
- An Excel chart is pasted into a Word document or PowerPoint presentation with its formatting and source workbook embedded.
- Observed behavior
- The embedded chart displays Edit Data, allowing viewers to access its source workbook.
Open the source Excel workbook and the Word document or PowerPoint presentation containing the chart. Identify every embedded chart that needs to be replaced before sharing the file.
Replace the Embedded Chart with a Picture
Use a picture when viewers need to see the chart but should not receive its embedded workbook.
Office 2013 does not provide a setting to disable Edit Data for an embedded chart. Pasting the chart as a picture avoids embedding its source workbook, but the picture will not update when the Excel data changes.
In Excel, select the chart and press Ctrl+C or choose Home > Copy.
In Word or PowerPoint, select the existing embedded chart and press Delete.
Place the cursor or select the slide where the chart belongs. Choose Home > Paste > Paste Special, select a Picture format, and click OK.
Select or right-click the pasted picture to confirm it is a picture rather than an editable chart. Repeat for any other embedded charts before saving and sharing the file.

Work with Charts in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and support for Microsoft Office formats, making it easier to move existing documents, presentations, and spreadsheets into a new workflow. It does not change the Edit Data behavior of embedded charts in Microsoft Office.

Frequently Asked Questions
Can I turn off Edit Data for an embedded chart in Office 2013?
No. Office 2013 does not provide a setting to disable Edit Data for an embedded chart. Paste the chart as a picture instead if viewers should not receive its embedded workbook.
How do I paste an Excel chart as a picture?
Copy the chart in Excel. In Word or PowerPoint, choose Home > Paste > Paste Special, select a Picture format, and click OK.
Will a chart pasted as a picture update when the Excel data changes?
No. A picture is a static representation. To show updated data, copy the updated chart from Excel and replace the picture.
Does deleting the embedded chart remove all source data from the file?
It removes that chart object, but data may still exist elsewhere in the document or presentation. Review other embedded objects and copies of the data before sharing.




