How to Prevent Excel for Mac from Updating Links After File Recovery
Question details
Users need to stop Excel for Mac from automatically updating links to other external workbooks after recovering a file from an unexpected shutdown.

- Product
- Excel for Mac
- Device & OS
- Mac
- Scenario
- Recovering a spreadsheet containing external links after the application unexpectedly shuts down.
- Observed behavior
- Excel for Mac may automatically update external links upon recovery, and the standard Windows instructions (File > Options > Advanced) do not exist in the Mac interface to disable this behavior.
Before modifying link settings or editing a recovered workbook, locate your original linked source files and verify they are uncorrupted.
Manage Link Settings via Excel Preferences and Data Tab
Use the macOS-specific Preferences menu and Edit Links tools to manage how external connections behave, bypassing the missing Windows Options menu.
Excel for Mac utilizes the native macOS menu bar instead of the Windows File ribbon. To control link behaviors and calculation settings, you must use the Preferences window or manually sever the links in the Data tab before they can update automatically.
Click on 'Excel' in the top macOS menu bar next to the Apple logo, then select 'Preferences' from the dropdown menu.
Click on 'Calculation' and review the options. If an option to 'Update links to other documents' is present in your specific Mac version, uncheck it.
If the preference is missing, open the recovered workbook, quickly navigate to the 'Data' tab on the ribbon, and click 'Edit Links'. Select the external workbooks you wish to disconnect and click 'Break Link' to convert them to static values.

Safely Handle and Isolate Recovered Files
Prevent unintended data overwrites by isolating the recovered workbook until you can safely verify its external data sources.
Try WPS Office for a Consistent Mac Spreadsheet Experience
If you are frustrated by the missing interface options and different menus in Excel for Mac compared to Windows, WPS Office offers a seamless solution. WPS Spreadsheets provides a familiar, unified interface across all operating systems, making link management and file recovery straightforward.
- 1. Download and Install: Visit the official WPS Office website and download the Mac version. Follow the installer instructions to set it up.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your .xlsx file.
- 3. Manage External Links: Navigate to the Data tab and use the intuitive link management tools to safely control or break external connections.

Frequently Asked Questions
Why can't I find File > Options in Excel for Mac?
Excel for Mac is built to follow macOS design guidelines, which place application-wide settings in the Mac menu bar. All settings found in the Windows 'Options' menu are relocated under 'Excel > Preferences' on Mac.
How do I force Excel for Mac to crash to test auto-recovery?
There is no officially supported way to intentionally crash Excel. You can simulate an unexpected shutdown by pressing Command + Option + Esc to open the Force Quit Applications window, selecting Microsoft Excel, and clicking 'Force Quit'. However, this is not recommended as it may cause data corruption.
Will breaking links in Excel delete my data?
No. When you break a link to an external workbook, Excel converts the previously linked formulas into static values. The data remains in your spreadsheet, but it will no longer update automatically if the external source file changes.




