'%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 Word Linked Excel Object Disappears After Reopening
Question details
Users experience disappearing Excel objects in Word that were inserted using Paste Special and Paste Link after saving and reopening the document.
- Product
- Microsoft Word and Excel
- Device & OS
- not provided
- Scenario
- A user inserts an Excel range into a Word document as a linked object using Paste Special, saves the file, and later reopens it.
- Observed behavior
- The linked Excel object vanishes from the document. The link might still appear in the Links dialog box but fails to refresh due to changed source paths, legacy formats, or storage locations.
Ensure both the Word document and the source Excel file are fully saved and accessible on your current local drive or network server before attempting to update or modify the links.
Verify Source File Path and Network Access Permissions
Check if the source Excel file has been moved, renamed, or restricted by network permission changes.
When dealing with linked objects across physical servers, Word relies on an exact file path to render the Excel data. If the folder structure changes or if your user account loses read permissions to the server share, the linked object will fail to display and appear as missing.
Open the Word document and navigate to File > Info, then look for and click on Edit Links to Files at the bottom right corner.
Review the source file path listed in the dialog box to ensure it perfectly matches the current location of the Excel file on your server or local drive.
Navigate to the Excel file's location in File Explorer and open the file directly to verify you have active read and write permissions for that specific folder or network share.
Prevent OneDrive Redirection and Update File Formats
OneDrive's automatic backup may redirect local save paths to the cloud, breaking physical server links. Updating legacy formats can also resolve display issues.
How to Link Spreadsheet Data Seamlessly in WPS Office
WPS Office provides a highly stable environment to link spreadsheet data directly into your text documents. Follow these easy steps to insert and maintain dynamically linked tables without worrying about forced cloud redirections.
- 1. Copy the Spreadsheet Data: Open your data in WPS Spreadsheet, select the desired range of cells you wish to link, and press Ctrl+C to copy.
- 2. Use Paste Special in WPS Writer: Open your document in WPS Writer, click the drop-down arrow directly under the Paste button on the Home tab, and select Paste Special.
- 3. Establish the Data Link: In the dialog box, choose 'Paste Link', select 'WPS Spreadsheet Object', and click OK to insert the dynamically linked spreadsheet data.
Frequently Asked Questions
Why does my linked Excel object show up as an empty box or completely disappear?
This typically happens if the original source file is moved, renamed, or if network access permissions change. This prevents Word from accessing the background Excel data needed to render the image in the document.
How do I refresh a linked Excel object in Word?
Right-click the linked object or the empty space where it should reside, and select 'Update Link'. You can also go to File > Info > Edit Links to Files, select the specific link, and click 'Update Now'.
Can saving files to OneDrive break my Paste Special links?
Yes. If your default save location is automatically shifted to OneDrive, the local physical path of the file changes to a cloud URL. This redirection often breaks existing local or physical server-based object links.
How do I view the current source path of a linked object to troubleshoot?
In Word, navigate to File > Info and click on 'Edit Links to Files' in the bottom right area. This dialog box displays the exact file paths Word is currently attempting to reference for all linked objects.
