Office for Mac Issues

Fix Read-Only Workbooks and External Links in Excel for Mac

Steve KSteve K Nov 20, 2026 869 views

Question details

The user needs to edit an Excel workbook and update its linked worksheet data on a Mac.

Fix Read-Only Workbooks and External Links in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
A workbook is opened from an email attachment or contains external references to other workbooks.
Observed behavior
The workbook may open as read-only or linked data may not update, without an expected prompt to enable editing or update links.
Before you start

Save the email attachment to a local folder and locate any source workbooks it links to. Make sure you have permission to edit the workbook and access the source files.

Solution 1Recommended

Save the Workbook Locally and Check Write Permission

Use this when an email attachment opens as read-only or cannot be edited.

1
Save the attachment

In your email app, save the workbook attachment to a local folder such as Documents instead of opening it directly from the message.

2
Check file permissions

In Finder, select the saved workbook and choose File > Get Info. Under Sharing & Permissions, confirm that your account has Read & Write access; request access from the owner if you cannot change it.

3
Reopen the workbook

Open the saved file from Finder in Excel and try editing a cell. If the file is still read-only, use File > Save As to create an editable copy in a folder where you have write access.

Save the Workbook Locally and Check Write Permission
Editing prompts can vary: Excel for Mac may not display the same Enable Editing prompt as Excel for Windows. Check whether you can edit the locally saved copy rather than relying on a prompt.
Free Microsoft Office alternative

Work with Spreadsheets in WPS Office for Mac

WPS Office is a free, lightweight alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move everyday spreadsheet work to WPS. It does not change Excel for Mac's permissions or link settings.

Open and edit spreadsheets in a familiar interfaceCompatible with common Microsoft Excel formats, including XLSX and XLSReview spreadsheet data in a lightweight office suiteMove common Office documents into one free workspace
microsoft office alternative - wps office

Frequently Asked Questions

Why does my email attachment open as read-only in Excel for Mac?

The attachment may have been opened from a restricted or temporary location. Save it to a local folder, then check File > Get Info > Sharing & Permissions in Finder for Read & Write access.

How do I find a broken external link in Excel for Mac?

Open the workbook and look under Data for Edit Links or Workbook Links. Review the source paths and use Change Source to select the correct file when available.

Do linked workbooks have to be in the same folder?

Not always. A relative link requires the source workbook to be in the expected location relative to the destination workbook. An absolute link must point to an accessible full path.

Should I enable macros to update linked data?

Only if the workbook relies on a macro for its update and you trust the file. Review Excel > Preferences > Security & Privacy or Macro Security; ordinary external links do not necessarily require macros.

What if Excel does not show an Enable Editing prompt?

The prompt may differ from Excel for Windows. Open a locally saved copy, check its permissions in Finder, and try editing a cell. If necessary, use File > Save As to create a copy in a writable folder.