Permission & Access Issues

How to Share Linked Excel Workbooks Without Exposing Source Files

Maira Mehtab Sep 27, 2026 868 views

Question details

The user wants to share a destination Excel workbook containing formulas linked to a confidential source workbook, without triggering SharePoint access requests or exposing the source file to end users.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing a Budget workbook that pulls calculated data from a confidential Master workbook stored in SharePoint.
Observed behavior: When users with access only to the destination workbook open it, they are prompted to request access to the confidential source workbook because the formulas attempt to refresh the external data.

Before you start

Ensure you have full administrator or edit access to both the source and destination workbooks in SharePoint before adjusting link settings.

Solution 1Recommended

Refresh and Save the Workbook as an Administrator Before Sharing

Prevent automatic data refresh triggers for end users by having an administrator update the linked values beforehand.

When an Excel file with external links is opened, it often attempts to update those links, which triggers a permission check in SharePoint. By refreshing the data manually through an admin account and saving it, users can view the latest calculated values without needing direct access to the source file.

Open both workbooks

Using an administrator account that has access to both files, open the confidential source workbook and the destination workbook.

Refresh external links

Allow the destination workbook to refresh its links so that all formulas pull the most recent data from the source workbook.

Save the destination workbook

Save and close the destination workbook to lock in the calculated values.

Instruct users

Share the destination workbook with end users and advise them to click 'Don't Update' if prompted about external links upon opening.

Contact Microsoft Support: If permission prompts continue despite users selecting 'Don't Update', contact Microsoft 365 Support to check your SharePoint tenant's specific sharing configurations.

Solution 2

Convert Linked Formulas to Static Values

If dynamic updates are no longer needed, removing the external links entirely is the safest way to prevent permission prompts.

Free Microsoft Office alternative

Manage and Share Spreadsheets Easily with WPS Office

If you frequently struggle with complex SharePoint permissions and Excel workbook link issues, try WPS Office. It provides a lightweight, highly compatible alternative for managing your spreadsheets securely and seamlessly.

1. Download WPS Office: Install WPS Office for free on your preferred device.
2. Open your workbook: Launch WPS Spreadsheets and open your .xlsx file directly without worrying about formatting loss.
3. Manage links securely: Use the built-in Data tools to break external links or paste formulas as values before safely sharing your document.

Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Lightweight software that opens large workbooks quicklyFree to use with a familiar, intuitive user interfaceEasy options for sharing, protecting, and exporting data securely

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel ask for permissions to another workbook when I open my file?

When a workbook contains formulas linking to an external file, Excel attempts to update the data upon opening. This triggers a background access check in SharePoint for the source file, causing a permission prompt if you do not have rights to view it.

Can I hide the formula bar so users don't see the source file name?

Yes, you can format the cells to 'Hidden' and then protect the worksheet. However, while this hides the file path in the formula bar, users might still receive a permission prompt if the workbook attempts to refresh the external data automatically on open.

How do I find which cells are linked to an external workbook?

You can find external links by going to the Data tab and clicking 'Edit Links' to see the source files. Alternatively, use the Find feature (Ctrl+F) and search for the '[' character, as Excel uses brackets to enclose external workbook names in formulas.

Document & File Issues