'%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)
How to Fix Linked Data Not Updating Between Workbooks in Excel Online
Question details
The user needs to refresh and display fully updated data in a destination workbook that is linked to a source workbook in Excel Online.
- Product
- Excel Online
- Device & OS
- not provided
- Scenario
- A source table updates daily, and the destination workbook linked to it must accurately reflect the complete, current dataset.
- Observed behavior
- The linked table in the destination Excel Online workbook does not display all the newly updated data from the source workbook.
Ensure both your source and destination workbooks are saved in a supported, unified cloud storage location like OneDrive or SharePoint, and verify that you have a stable internet connection.
Refresh Browser and Verify Cloud Storage Locations
Force a browser refresh to pull the latest cloud data and ensure both files are located in the same cloud environment to allow seamless syncing.
Excel Online relies heavily on cloud synchronization to update Paste Link connections. If the workbooks are stored in different environments or the browser cache prevents the latest data from displaying, the destination workbook will appear outdated.
Open the source workbook in Excel Online, make a recognizable data change, and wait for the 'Saved' indicator at the top to confirm the update has reached the cloud.
Open the destination workbook containing the Paste Link table in a separate browser tab within the same browser session.
Refresh the web browser page completely by pressing F5 or clicking the browser's reload button to force Excel Online to fetch the latest linked data.
If data is still missing, check the file path of both workbooks. Ensure both are saved in the exact same cloud environment (e.g., both in the same SharePoint site or both in your personal OneDrive) to prevent synchronization blocks.
Easily Link and Update Data Across Workbooks with WPS Office
WPS Spreadsheets provides robust support for linking data across multiple workbooks. Whether you are working offline or syncing via WPS Cloud, you can effortlessly manage external references, refresh data instantly, and ensure your datasets are always up to date.
- 1. Open your workbooks: Launch WPS Spreadsheets and open both the source and destination workbooks in the same application window.
- 2. Copy the source data: Highlight the required data range in the source workbook, right-click, and select 'Copy'.
- 3. Paste as a link: Navigate to the destination workbook, right-click the target cell, select 'Paste Special', and click the 'Paste Link' button.
- 4. Update data links: To manually refresh data later, go to the 'Data' tab, click 'Edit Links', select your source file from the list, and click 'Update Values'.
Frequently Asked Questions
Why is the 'Paste Link' option disabled in Excel Online?
The 'Paste Link' option may be disabled if the workbooks are not stored in the same cloud environment (like both in OneDrive or both in SharePoint), or if you are copying between completely different browser instances instead of tabs within the same browser session.
How do I manually update linked data in the Excel desktop app?
In the Excel desktop app, go to the 'Data' tab, click on 'Edit Links' (or 'Queries & Connections' depending on your version), select the linked source file, and click 'Update Values' to pull the latest data into your destination workbook.
Can I link a locally saved workbook to an Excel Online workbook?
No, Excel Online requires both the source and destination workbooks to be saved and hosted in a compatible Microsoft cloud service (such as OneDrive or SharePoint) for live external links to function properly.
