Fix the Publisher 2016 OLE Server Error When Pasting an Excel Chart
Question details
The user needs to paste an Excel 2016 chart into a Publisher 2016 publication despite an OLE server error.

- Product
- Microsoft Publisher 2016 and Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Copying a chart from an Excel workbook into a Publisher publication.
- Observed behavior
- Publisher reports that it cannot launch or communicate with the OLE server when the chart is pasted.
Open the Excel workbook and Publisher publication, and select the chart you want to copy. Decide whether you need an editable chart or whether a static picture is sufficient.
Paste the Excel chart into Publisher as a picture
Use this workaround when a static chart image is sufficient.
In Excel 2016, select the chart and press Ctrl+C.
In Publisher 2016, click where you want the chart, then open the Home tab and choose Paste > Paste Special.
Select Picture (Enhanced Metafile) and click OK.

Copy the chart through Microsoft Word
Try using Word as an intermediate step if a direct paste from Excel fails.
Paste the chart from the Publisher Clipboard
Try the Office Clipboard in Publisher as an alternative to a direct paste.
Work with Excel charts in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and documents. Open compatible Microsoft Office files to make migration easier. WPS Office does not fix the Publisher OLE error.

Frequently Asked Questions
Why does Publisher show an OLE server error when I paste an Excel chart?
The error indicates that Publisher cannot launch or communicate with the OLE server needed for the paste. The message alone does not identify the underlying cause.
Can I paste the chart without using an editable Excel object?
Yes. Copy the chart in Excel, then in Publisher choose Home > Paste > Paste Special and select Picture (Enhanced Metafile). The result is a static image.
Will the pasted picture update when I change the Excel data?
No. A chart pasted as an enhanced metafile is a static picture. Copy and paste the updated chart again if its data changes.
What can I try if Paste Special does not give me the result I need?
Try copying the chart into Word first, then copying it from Word into Publisher. You can also open the Clipboard pane on Publisher's Home tab and paste the copied chart from there.
Does WPS Office fix the Publisher OLE server error?
No. WPS Office is an alternative for working with compatible spreadsheets and documents; it does not repair an OLE error in Microsoft Publisher.




