File Sharing Problems

How to Mirror a Word Table in an Excel Spreadsheet on OneDrive

Maira Mehtab Sep 21, 2026 869 views

Question details

The user wants to sync or mirror data between a Word document and an Excel workbook stored on OneDrive, ensuring changes are reflected while maintaining formatting and analysis capabilities.

Product: Microsoft Word / Microsoft Excel
Device & OS: not provided
Scenario: Linking data across Office documents stored on OneDrive to maintain consistency without manual copying.
Observed behavior: Data needs to be mirrored dynamically between Word and Excel so that updates in the source file automatically reflect in the destination file.

Before you start

Ensure you have the desktop versions of both Word and Excel installed, as the Paste Special linking feature requires the desktop applications rather than the web versions to establish the connection.

Solution 1Recommended

Use Paste Special to Link Excel Data to Word

Link an Excel range directly into your Word document as an object so it automatically updates when the source workbook changes on OneDrive.

While the initial request mentions mirroring a Word table in Excel, the most reliable native method for Office documents is maintaining the source data in Excel and linking it to Word. This preserves Excel's robust data analysis tools while keeping the Word report up to date.

Open both files in desktop apps

Open your target workbook in the Excel desktop application and your document in the Word desktop application. They must be opened locally, not in the browser.

Copy the Excel data

In Excel, select the specific range of cells you want to mirror and copy it by pressing Ctrl+C or right-clicking and selecting Copy.

Use Paste Special in Word

Switch to your Word document. Navigate to the Home tab on the ribbon, click the dropdown arrow under the Paste button, and select Paste Special.

Create the link

In the Paste Special dialog box, select the Paste link radio button, choose Microsoft Excel Worksheet Object from the list of formats, and click OK.

Web App Limitation: This linking feature only works in the desktop versions of Word and Excel. If you open the files in Office Online, the links will not update dynamically.

WPS Office Solution

Link Spreadsheets and Documents Seamlessly with WPS Office

WPS Office provides a highly compatible suite where you can easily link spreadsheet data directly into your text documents using the exact same Paste Special mechanics, keeping your reports perfectly synced.

1. Open WPS Spreadsheet and Writer: Launch WPS Office and open both your source spreadsheet and target document.
2. Copy Spreadsheet Data: Highlight the table or data range in WPS Spreadsheet, right-click, and select Copy.
3. Paste Special in Writer: Go to WPS Writer, click the Home tab, click the Paste dropdown arrow, and select Paste Special.
4. Paste as Link: Choose Paste Link in the dialog box, select WPS Spreadsheets Object, and click OK to mirror the data.

Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) formatsSeamlessly copy and paste data links between WPS Spreadsheet and WPS WriterLightweight application that runs smoothly on Windows, Mac, and LinuxBuilt-in cloud sync capabilities with WPS Cloud to keep files updated anywhere

microsoft office alternative - wps office

Frequently Asked Questions

Why is my linked table not updating automatically on OneDrive?

If your files are stored on OneDrive and opened in the web browser, automatic updates won't trigger because OLE links require the desktop environment. You must open the files in the desktop application and ensure your Trust Center settings allow automatic updates for external links.

Can I mirror a Word table directly into an Excel spreadsheet instead?

While you can embed a Word document into Excel using Insert > Object, it is generally recommended to keep the source data in Excel and link it to Word. Excel is optimized for data storage and analysis, making it a much more stable source file for mirroring.

Will the linked data retain tracked changes?

Tracked changes made in the source file will be reflected in the linked object's final output, but the visual tracking markers (like red strikethroughs) might not display in the destination file exactly as they do in the source.

Does Paste Link work on Mac?

Yes, Paste Special and Paste Link function on the Mac desktop versions of Office. The exact object names in the dialog box might differ slightly (e.g., Microsoft Excel Worksheet Object), but the linking behavior remains the same.

Document & File Issues