Office for Mac Issues

Fix Excel for Mac OLE Action Error When Creating Word Documents

Bushra ParveenBushra Parveen Nov 20, 2026 869 views

Question details

Resolve repeated OLE action messages when an Excel macro creates a Word document on a Mac.

Fix the Excel for Mac OLE Action Error When Creating Word Documents
Product
Microsoft Excel and Word for Microsoft 365 for Mac
Device & OS
Mac
Scenario
An Excel VBA macro copies worksheet ranges into a Word document after an upgrade to Microsoft 365 for Mac.
Observed behavior
Excel repeatedly reports that it is waiting for another application to complete an OLE action.
Before you start

Open the workbook and identify the macro statements that copy Excel ranges into Word. Confirm that the macro already creates or opens a Word document and assigns it to a document variable.

Solution 1Recommended

Paste Excel Ranges into Word as Pictures

Use this workaround when copying a formatted Excel range into Word triggers the OLE action message.

Copying the range as a picture avoids transferring its original editable formatting. This may resolve the error when the formatted paste is the cause, but it does not address every possible Word automation issue.

1
Open the macro

In Excel for Mac, open the workbook and choose Tools > Macro > Visual Basic Editor. Find the macro that creates the Word document.

2
Replace the range copy

Find the statement that copies the worksheet range and replace it with Worksheets("Sheet1").Range("A1:B10").CopyPicture. Change the sheet name and range to match your workbook.

3
Paste into the Word document

After the CopyPicture statement, use wd.Range(wd.Content.End - 1, wd.Content.End - 1).Paste, where wd is the Word Document object already created or opened by your macro. This inserts the picture at the end of the document.

4
Run the revised macro

Return to Excel, run the macro from Tools > Macro > Macros, and check the Word document and any remaining OLE messages.

Paste Excel Ranges into Word as Pictures
The pasted range is a picture: The content will not be editable as a Word table. Edit the source cells in Excel and paste the range again if the data changes.
Free Microsoft Office alternative

Work with Spreadsheets and Documents in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and documents. Open compatible Office files to move your manual editing workflow to WPS; it does not fix Microsoft Office OLE errors, and existing automation may not work the same way.

Work with spreadsheet ranges and documents in one office suiteOpen and edit compatible Microsoft Excel XLSX and Word DOCX filesUse a familiar interface for a smoother move from Microsoft OfficeGet a free, lightweight option for everyday document editing
microsoft office alternative - wps office

Frequently Asked Questions

Can I edit the pasted Excel range as a Word table?

No. CopyPicture pastes the range as an image. To change the data, edit the cells in Excel and paste a new picture into Word.

Where do I edit the macro in Excel for Mac?

Open the workbook and choose Tools > Macro > Visual Basic Editor. Locate the procedure that copies the range into Word.

What does wd refer to in the paste statement?

It refers to the Word Document object created or opened by your macro. If your document variable has a different name, use that name in the paste statement.

Should I follow Windows instructions for disabling DDE or Excel add-ins?

No. DDE advice is Windows-specific, and Excel for Mac does not have the Windows File > Options menu. First check the macro's copy-and-paste statements instead.