logo
search
Office Apps Crashing

Fix Excel Crashes When Saving Workbooks with Word OLE Links

WPS EditorWPS Editor Oct 8, 2026 869 views

Question details

Excel freezes and crashes when attempting to save a workbook that contains a Paste Link connection inserted as Unicode Text from a Word table.

How to Fix Excel Crashing When Saving Workbooks with Word OLE Links
Product
Microsoft Excel
Device & OS
Windows
Scenario
Saving a workbook after copying a table cell from Microsoft Word and using 'Paste Special > Paste Link > Unicode Text' in Excel.
Observed behavior
The Excel application hangs, crashes, and automatically attempts to reopen the file as a recovered XLSB (binary) workbook, causing the OLE links to break and stop updating.
Before you start

Before modifying your workbook, ensure you create a backup of both the source Word document and the Excel file. Close any unnecessary background applications to prevent system-wide freezes during the recovery process.

Solution 1Recommended

Replace the OLE Paste Link with Standard Embedded Data

Avoid the software crash by removing the problematic Unicode Text OLE link and using a standard data paste or embedding method.

This crash is a known bug associated with how Excel processes Unicode Text links from Word tables during the save operation. Breaking the link and pasting the data directly prevents the hang.

1
Open the recovered workbook

Launch Excel and open the recovered XLSB file or the last saved version of your workbook.

2
Remove the existing OLE link

Locate the cell containing the Paste Link from Word. Right-click the cell and clear its contents to remove the unstable connection.

3
Recopy the Word data

Open your Microsoft Word document, highlight the required table cell, and press Ctrl+C to copy the data.

4
Paste without linking

Return to Excel, select the destination cell, right-click, and choose 'Paste Options > Keep Source Formatting' or 'Values' instead of using Paste Link.

Replace the OLE Paste Link with Standard Embedded Data
Alternative Link Options: If you absolutely must link the data dynamically, try importing the data using Power Query or embedding the entire Word object instead of using Paste Link as Unicode Text.
Free Microsoft Office alternative

Switch to WPS Office for Stable Data Management

If Microsoft Excel continues to crash when managing cross-application data, consider switching to WPS Office. It provides a highly stable, lightweight environment for handling complex spreadsheets and data pasting without unexpected freezing or crashing.

  1. 1. Download and install WPS Office: Visit the official WPS website and download the free WPS Office suite for Windows.
  2. 2. Open your existing files: Launch WPS Spreadsheets and seamlessly open your existing .xlsx or .xlsb workbooks.
  3. 3. Edit without crashing: Paste your table data from Writer to Spreadsheets safely and save your progress instantly.
Highly stable performance for cross-document data pasting and linking.Fully compatible with Microsoft Excel (.xlsx, .xlsb) and Word (.docx) file formats.Lightweight software architecture ensures fast loading and smooth saving processes.Familiar user interface requires no learning curve for Office users.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel crash specifically when saving the workbook?

Excel attempts to refresh and validate all OLE links during the save process. When processing a Paste Link formatted specifically as Unicode Text from a Word table, a bug causes a memory loop, leading Excel to hang and eventually crash.

What is an XLSB file and why does Excel recover my file as one?

An XLSB file is an Excel Binary Workbook. When Excel experiences a critical failure and forces a recovery, it often saves the recovered data in binary format (.xlsb) because it is faster to write and optimized for recovering raw data from corrupted files.

Can I still dynamically link Word data to Excel without crashing?

Yes, but you should avoid the 'Unicode Text' format. Try pasting the link as an 'HTML Format' or standard 'Microsoft Word Document Object'. Alternatively, use Power Query to import data dynamically without relying on fragile OLE links.