Permission & Access Issues

Disable Edit Data for Embedded Charts in Word and PowerPoint

Nimra MalikNimra Malik Nov 20, 2026 869 views

Question details

Prevent viewers from accessing an Excel chart's source workbook through Edit Data in Word or PowerPoint.

Disable Edit Data for Embedded Charts in Word and 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.
Before you start

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.

Solution 1Recommended

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.

1
Copy the source chart

In Excel, select the chart and press Ctrl+C or choose Home > Copy.

2
Remove the embedded chart

In Word or PowerPoint, select the existing embedded chart and press Delete.

3
Paste as a picture

Place the cursor or select the slide where the chart belongs. Choose Home > Paste > Paste Special, select a Picture format, and click OK.

4
Check the replacement

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.

Replace the Embedded Chart with a Picture
Check for other copies of the data: Replacing a chart does not remove source data stored elsewhere in the document or presentation. Review the file for other embedded objects or copies of the data before sharing.
Free Microsoft Office alternative

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.

Work with spreadsheet charts, documents, and presentations in one suiteOpen and edit Microsoft Office formats including XLSX, DOCX, and PPTXUse a familiar interface for a smoother transition from Microsoft OfficeAccess a free, lightweight office suite
microsoft office alternative - wps 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.