'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Table Pasting Incorrectly into Word for the Web
Question details
Users experience missing formulas, lost formatting, and broken data links when copying an Excel table and pasting it into a Word document via the web browser.
- Product
- Word for the web, Excel
- Device & OS
- not provided
- Scenario
- Attempting to paste a copied Excel table into a Word document using the online web version, expecting dynamic links and formulas to be preserved.
- Observed behavior
- Text and basic formatting may transfer, but formulas and linked functionalities fail to paste. This happens because Word for the web has limited clipboard and object-insertion capabilities compared to the desktop version.
Check whether you need the table data in your document to update automatically when the original spreadsheet changes, as this requires specific pasting methods only available in desktop applications.
Use the Desktop Versions of Word and Excel
Switching to the desktop applications allows you to use Object Linking and Embedding (OLE), which correctly preserves links, formulas, and formatting.
Word for the web does not support inserting linked Excel objects. To maintain a live connection between your spreadsheet and your document, you must perform the action using the fully featured desktop software.
At the top of Word for the web, click the 'Viewing' or 'Editing' button, and select 'Open in Desktop App' to launch Microsoft Word on your computer.
Open your spreadsheet in the desktop version of Excel, highlight the table data you need, and press Ctrl+C (Windows) or Cmd+C (Mac) to copy it.
Return to your Word document, place your cursor where you want the table, navigate to the Home tab, click the arrow under 'Paste', and select 'Paste Special'.
In the Paste Special dialog box, select 'Paste link', choose 'Microsoft Excel Worksheet Object', and click 'OK'.
Paste as Static Values in Word for the Web
If you cannot use a desktop application and only need the raw data, pasting as static values prevents formatting errors and broken links in the web editor.
Paste and Link Spreadsheets Flawlessly with WPS Office
Bypass the limitations of web-based document editors by switching to WPS Office. The powerful, free WPS desktop suite fully supports Object Linking and Embedding (OLE), allowing you to seamlessly link spreadsheet data into your documents while perfectly preserving Microsoft Office formats.
- 1. Download and launch WPS Office: Install the free WPS Office desktop application and open your workspace.
- 2. Copy from WPS Spreadsheet: Open your Excel or WPS spreadsheet file, select the table, and press Ctrl+C to copy.
- 3. Open document in WPS Writer: Switch to your Word or WPS document and place your cursor where you want the table inserted.
- 4. Insert via Paste Special: Go to the Home tab, click the drop-down arrow beneath the Paste button, and select 'Paste Special'.
- 5. Link the table: Select 'Paste Link' and choose 'WPS Spreadsheets Object' to insert a dynamically updating table.
Frequently Asked Questions
Why does my Excel table lose formatting when pasted online?
Web browsers and online editors restrict direct clipboard access and lack support for advanced object embedding protocols like OLE. This forces the application to paste a simplified, static version of your data, stripping away complex formatting and formulas.
Can I link an Excel file to a Word document on a Mac?
Yes. While web versions don't support it, the desktop versions of Word for Mac and WPS Office for Mac both support the 'Paste Special' > 'Paste Link' functionality.
How do I update a linked table if the source file changes?
If you inserted the table using 'Paste Link' in a desktop app, it should update automatically when you open the document. You can also manually update it by right-clicking the table in your document and selecting 'Update Link'.
Is it possible to embed an entire Excel workbook in Word?
Yes, but only in desktop applications. In Word or WPS Writer, you can go to the Insert tab, select 'Object', and choose to create a new spreadsheet object or insert an existing file. This cannot be done in Word for the web.
