Fix Excel for Mac OLE Action Error When Creating Word Documents
Question details
Resolve repeated OLE action messages when an Excel macro creates a Word document on a Mac.

- 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.
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.
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.
In Excel for Mac, open the workbook and choose Tools > Macro > Visual Basic Editor. Find the macro that creates the Word document.
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.
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.
Return to Excel, run the macro from Tools > Macro > Macros, and check the Word document and any remaining OLE messages.

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.

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.




