Fix Excel Workbook Links Showing Old Values in OneDrive
Question details
The user needs to resolve an issue where an Excel workbook stored in OneDrive fails to automatically update its external links, displaying outdated calculated values instead of the latest data.

- Product
- Microsoft Excel, OneDrive
- Device & OS
- not provided
- Scenario
- Storing and sharing interconnected Excel workbooks in a cloud environment (OneDrive) where automatic external link calculation fails to trigger.
- Observed behavior
- The dependent workbook displays old values from the source workbook. The new values only appear if the links are manually updated by navigating to Data > Edit Links > Update Values.
Ensure you have a stable internet connection so OneDrive can sync your files properly, and verify that both the source and destination workbooks are fully synced to the cloud without any pending upload errors.
Configure Automatic Update for External Links
Modify Excel's trust center and data connection settings to allow external references to refresh automatically when the workbook is opened.
By default, Excel may block external links from updating automatically for security reasons, especially when files are accessed via cloud paths like OneDrive or SharePoint. Adjusting these settings ensures your values stay current.
Open the destination workbook that is showing the old values. Click on 'File' in the top-left corner, then select 'Options' at the bottom of the menu.
In the Excel Options window, click on 'Advanced' in the left sidebar. Scroll down to the 'General' section and ensure the box for 'Ask to update automatic links' is checked, so Excel prompts you to refresh the data upon opening.
Still in the Options menu, go to 'Trust Center' and click the 'Trust Center Settings' button. Navigate to the 'External Content' tab on the left.
Under the 'Security settings for Workbook Links' section, select 'Enable automatic update for all Workbook Links (not recommended)'. Click 'OK' to save your changes.
Go to the 'Data' tab on the main ribbon and click 'Edit Links'. Click the 'Startup Prompt' button and select 'Don't display the alert and update links' if you want a seamless background refresh.

Manually Refresh or Reconnect Broken OneDrive Links
If automatic updates fail due to OneDrive altering the file path to an HTTPS URL, manually reconnecting the links often restores normal sync behavior.
Easily Handle Connected Workbooks with WPS Spreadsheet
WPS Spreadsheet offers robust support for external workbook references with intuitive data management tools, ensuring your calculated values are always up to date whether saved locally or in the cloud.
- 1. Open Linked Workbooks: Launch WPS Spreadsheet and open both your source and destination workbooks.
- 2. Access Link Settings: Navigate to the 'Data' tab on the top ribbon and click on 'Edit Links'.
- 3. Update Data: Select your linked source file and click 'Update Values' to instantly refresh the linked cells.
- 4. Configure Startup Prompts: Click 'Startup Prompt' in the Edit Links dialog to configure the workbook to automatically update links upon opening.

Frequently Asked Questions
Why do Excel links break or show old values when moved to OneDrive?
When files are moved to OneDrive, their file paths change from local drive letters (like C:\) to HTTPS cloud URLs. This sudden path change can cause Excel to lose the connection to the source file, preventing automatic updates and displaying cached, old values.
Can I force Excel to update all external links at once?
Yes, you can go to the Data tab, click Edit Links, select all linked sources by holding down the Shift or Ctrl key, and then click Update Values to refresh everything simultaneously.
Does keeping both workbooks open help with link updates?
Yes. Opening both the source and the destination workbooks at the same time in Excel generally forces the application to recalculate formulas and sync the links instantly without requiring manual updates.




