Office for Mac Issues

How to Prevent Excel for Mac from Updating Links After File Recovery

Bushra ParveenBushra Parveen Oct 16, 2026 871 views

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.

How to Prevent Excel for Mac from Updating Links After File Recovery
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 you start

Before modifying link settings or editing a recovered workbook, locate your original linked source files and verify they are uncorrupted.

Solution 1Recommended

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.

1
Access Excel Preferences

Click on 'Excel' in the top macOS menu bar next to the Apple logo, then select 'Preferences' from the dropdown menu.

2
Adjust Calculation Settings

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.

3
Manually Break Links

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.

Manage Link Settings via Excel Preferences and Data Tab
Menu Differences: Do not look for a 'File > Options' menu. This is exclusive to the Windows version of Microsoft Office and does not exist on macOS.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS Office website and download the Mac version. Follow the installer instructions to set it up.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your .xlsx file.
  3. 3. Manage External Links: Navigate to the Data tab and use the intuitive link management tools to safely control or break external connections.
Highly compatible with Microsoft Excel (.xlsx, .xls) files and external links.Consistent interface design across Mac and Windows, eliminating missing menu confusion.Reliable built-in document recovery and easy-to-find external link management tools.Lightweight, fast, and entirely free to use for everyday spreadsheet tasks.
microsoft office alternative - wps office

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.