Calculation Issues

Fix Excel Workbook Links Showing Old Values in OneDrive

Nimra MalikNimra Malik Nov 2, 2026 868 views

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.

How to Fix Excel Workbook Links Showing Old Values in OneDrive
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel Options

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.

2
Adjust Advanced General Settings

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.

3
Configure Trust Center

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.

4
Enable Workbook Links

Under the 'Security settings for Workbook Links' section, select 'Enable automatic update for all Workbook Links (not recommended)'. Click 'OK' to save your changes.

5
Set Startup Prompt

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.

Configure Automatic Update for External Links
Security Consideration: Enabling automatic updates for all workbook links can be a security risk if you frequently open files from unknown sources. Only use this setting if you trust all linked documents in your OneDrive.
Manage External Links Seamlessly

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. 1. Open Linked Workbooks: Launch WPS Spreadsheet and open both your source and destination workbooks.
  2. 2. Access Link Settings: Navigate to the 'Data' tab on the top ribbon and click on 'Edit Links'.
  3. 3. Update Data: Select your linked source file and click 'Update Values' to instantly refresh the linked cells.
  4. 4. Configure Startup Prompts: Click 'Startup Prompt' in the Edit Links dialog to configure the workbook to automatically update links upon opening.
Fully compatible with Microsoft Excel (.xlsx) file formats and existing external link formulas.Reliable data refreshing mechanisms without complex Trust Center configurations.Built-in WPS Cloud ensures smooth synchronization of linked documents across devices.Free, lightweight, and features a user-friendly interface for effortless data management.
microsoft office alternative - wps office

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.