How to Fix Excel Workbook Links Not Refreshing on Mac
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.

- 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.
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.
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.
Open your Excel workbook, navigate to the 'Data' tab on the ribbon, and click on 'Edit Links' (or 'Workbook Links').
Review the list of linked files in the dialog box to identify any links displaying an 'Error' status.
Select the broken link and click 'Change Source' to open a Finder window. Navigate to the current, correct location of the source file.
Select the file, confirm the selection, and click 'Update Values' to re-establish the connection. Save the document immediately.

Check macOS Folder Permissions for Excel
Ensure Microsoft Excel has the necessary macOS permissions to access files stored in local folders or network drives.
Update Microsoft Excel and macOS
Software bugs, particularly on Macs with newer Apple Silicon processors, can cause link refreshing issues that are resolved in subsequent updates.
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. Download and Install: Visit the WPS Office website and download the Mac version.
- 2. Open Your Spreadsheets: Open your existing .xlsx files directly in WPS Spreadsheet without worrying about format conversion.
- 3. Manage Data Links: Use the intuitive Data tab to effortlessly manage, create, and update your workbook links.

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.




