Permission & Access Issues

Link Excel Workbooks in SharePoint Without Exposing the Source File

Ayan MasoodAyan Masood Nov 14, 2026 868 views

Question details

Connect an Excel form or dashboard to data stored in a SharePoint workbook without letting users open the confidential source file.

Link Excel Workbooks in SharePoint While Restricting Source Access
Product
Microsoft Excel and SharePoint
Device & OS
not provided
Scenario
A dashboard or form needs values from a database workbook stored in SharePoint, while the source file must remain restricted.
Observed behavior
The desired setup shares only permitted data with dashboard users without granting them access to the complete source workbook.
Before you start

Identify which source fields dashboard users are allowed to see and check their SharePoint permissions for both workbooks. Decide whether users need live refresh or whether a periodically published copy of approved data is sufficient.

Solution 1

Use Paste Link When Users Can Access the Source Workbook

Create a direct workbook link when giving dashboard users access to the source file is acceptable.

External workbook links generally require the user refreshing them to have access to the source workbook. They are not a reliable way to hide a confidential source while allowing users to refresh its data.

1
Check source permissions

In SharePoint, select the source workbook and open Manage access. Confirm that intended users have appropriate access before relying on a direct link.

2
Copy the source cell

Open both workbooks in Excel, select the source cell, and choose Home > Copy.

3
Create the link

In the form or dashboard workbook, select the destination cell and choose Home > Paste > Paste Special > Paste Link.

4
Test the refresh

Save the dashboard to SharePoint, then have a representative user open it and refresh the workbook link using Excel's link controls. Confirm that the displayed value updates.

Previously displayed values may remain: A linked workbook can retain previously saved values even when a user cannot refresh the source. Do not place confidential results in a dashboard that unauthorized users can open.
Free Microsoft Office alternative

Work with Excel-Compatible Dashboards in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and compatibility with Excel files, making it easier to move everyday spreadsheet work between applications. SharePoint permissions and secure data publishing still need to be managed separately.

Open and edit spreadsheet dashboards in a familiar interfaceCompatible with Microsoft Excel XLSX filesFree and lightweight for everyday office workMove existing Excel files into a familiar office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can users refresh an Excel workbook link without access to the source file?

Generally, users need access to the source workbook to refresh an external link. For a confidential source, publish approved data separately or use a controlled service instead.

Does Power Query hide a confidential workbook from dashboard users?

Not by itself. Power Query needs credentials authorized to access its source, and data loaded into a workbook may be visible to users who can open it. Connect to a source that exposes only approved data.

How do I check who can open the source workbook?

In SharePoint, select the source workbook and open Manage access. Review the people and groups with access, including access inherited from the site or library.

Will removing source access remove values already saved in the dashboard?

Not necessarily. Previously saved or cached values can remain in the dashboard even if the link can no longer refresh. Review the dashboard's contents before sharing it.