Office for Mac Issues

How to Fix Excel Workbook Links Not Refreshing on Mac

Bushra ParveenBushra Parveen Nov 10, 2026 869 views

Question details

The user's Excel workbook links on a Mac fail to refresh permanently, requiring manual relinking of multiple spreadsheets after closing the application.

How to Fix Excel Workbook Links Not Refreshing on Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
Attempting to update or refresh data from linked workbooks in Excel for Mac.
Observed behavior
Using 'Refresh All' updates the links temporarily, but the connection breaks again once Excel is closed, forcing the user to manually relink the spreadsheets.
Before you start

Ensure that all linked source files are currently accessible on your Mac or network drive and have not been renamed or moved to a different folder.

Solution 1Recommended

Verify Source File Paths and Update Workbook Links

Check if the source workbooks have been moved or renamed, and manually update the broken links to establish a permanent connection.

When source files are moved, renamed, or temporarily unavailable, Excel loses the file path connection. Relinking them directly through the Edit Links menu usually creates a persistent fix.

1
Open Link Settings

Open your Excel workbook, navigate to the 'Data' tab on the ribbon, and click on 'Edit Links' (or 'Workbook Links').

2
Identify Broken Links

Review the list of linked files in the dialog box to identify any links displaying an 'Error' status.

3
Change Source

Select the broken link and click 'Change Source' to open a Finder window. Navigate to the current, correct location of the source file.

4
Update Values

Select the file, confirm the selection, and click 'Update Values' to re-establish the connection. Save the document immediately.

Verify Source File Paths and Update Workbook Links
Network Drives: If the source file is located on a network drive, ensure the drive is fully mounted in macOS Finder before opening the Excel file.
Free Microsoft Office alternative

Try WPS Office for Mac for Reliable Spreadsheet Management

If Excel for Mac continues to struggle with broken links and performance issues, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative that handles complex spreadsheets and data linking effortlessly.

  1. 1. Download and Install: Visit the WPS Office website and download the Mac version.
  2. 2. Open Your Spreadsheets: Open your existing .xlsx files directly in WPS Spreadsheet without worrying about format conversion.
  3. 3. Manage Data Links: Use the intuitive Data tab to effortlessly manage, create, and update your workbook links.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Stable and reliable data linking between multiple workbooks.Lightweight design optimized for Mac, including Apple Silicon processors.Free to use with a familiar tabbed interface for seamless migration.
microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel links break after closing the file on Mac?

This often happens if the source file is located on an unmounted network drive, inside a cloud-synced folder that changes local file paths, or due to a known bug in specific versions of Excel for Mac. Ensuring static file paths and updated software usually resolves it.

How do I find all external links in an Excel workbook?

You can find all external links by navigating to the Data tab on the ribbon and selecting 'Edit Links'. Alternatively, you can use the Find feature (Cmd + F) and search for '.xl' or the bracket symbol '[' to locate cells referencing other external workbooks.

Can Apple Silicon (M1/M2/M3) processors cause Excel link issues?

Some older versions of Excel for Mac experienced compatibility glitches and performance issues on Apple Silicon architecture. Ensuring both macOS and Microsoft Office are updated to their latest native versions usually patches these processor-specific bugs.

How can I stop Excel from asking to update links every time I open a file?

To manage the update prompt, go to Data > Edit Links, click on 'Startup Prompt' in the dialog box, and select 'Don't display the alert and update links'. This will automate the updating process without prompting you every time.