'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel for the Web Cannot Open Shared Workbook on Mac
Question details
The user is unable to open a shared Excel workbook using Excel for the Web on a Mac because the file contains external references to local files on the owner's computer.
- Product
- Excel for the Web
- Device & OS
- Mac
- Scenario
- Attempting to open and collaborate on a shared Excel file via a web browser.
- Observed behavior
- Excel for the Web blocks access to the file and displays an error due to the presence of unsupported charts or objects containing external references to local workbooks.
Verify your internet connection and check with the file owner to confirm if the shared workbook contains links to other spreadsheets stored locally on their computer.
Remove or Break External References in the Original Workbook
The most effective way to make the file accessible in Excel for the Web is for the owner to remove unsupported local file links.
Excel for the Web has strict limitations and cannot process external references linking to a user's local hard drive. The file owner must break these links and convert the data to static values before sharing.
The workbook owner must open the original file in their desktop version of Excel.
Go to the 'Data' tab on the top ribbon and click on the 'Edit Links' option.
Select the linked local workbooks from the list and choose 'Break Link' to convert all external references to static values.
Save a new copy of the updated workbook, upload it to the cloud, and generate a new sharing link for collaborators.
Request the File as an Attachment and Open Locally
Bypass browser limitations completely by opening the file directly in a desktop spreadsheet application on your Mac.
Open and Edit Complex Workbooks Locally with WPS Office
If you frequently encounter browser limitations or external link errors with Microsoft Excel for the Web, WPS Office provides a robust, free desktop alternative. It handles complex workbooks seamlessly on your Mac without forcing you into restricted web views.
- 1. Download WPS Office: Visit the official WPS website and download the free desktop application for Mac.
- 2. Install the application: Follow the on-screen instructions to install WPS Office on your Mac.
- 3. Open your workbook: Launch WPS Spreadsheets, click 'Open', and select your downloaded shared workbook to edit it with full feature support.
Frequently Asked Questions
Why does Excel for the Web not support external references?
Excel for the Web runs in a browser environment and does not have security access to the local file system of the computer where the linked files reside. Therefore, it cannot retrieve or calculate data from external workbooks stored on a local hard drive.
How can I tell if my Excel file has external links?
In the Excel desktop app, go to the 'Data' tab and look for the 'Edit Links' option. If the button is clickable, your workbook contains links to other files. If it is grayed out, there are no external links present.
Can I view the shared workbook without editing it if it has external links?
In some cases, Excel for the Web may allow you to open the file in a restricted 'View Only' mode. However, if the workbook contains complex charts or objects heavily relying on local links, the web app may completely block access.
Is there a way to keep external links and still collaborate online?
Yes, but both the main workbook and the externally linked workbooks must be uploaded to the same cloud storage platform (such as OneDrive or SharePoint). The links must then be updated to point to the cloud locations rather than local computer drives.
