Link Excel Workbooks in SharePoint Without Exposing the Source File
Question details
Connect an Excel form or dashboard to data stored in a SharePoint workbook without letting users open the confidential source file.

- 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.
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.
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.
In SharePoint, select the source workbook and open Manage access. Confirm that intended users have appropriate access before relying on a direct link.
Open both workbooks in Excel, select the source cell, and choose Home > Copy.
In the form or dashboard workbook, select the destination cell and choose Home > Paste > Paste Special > Paste Link.
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.
Publish Approved Data Through a Controlled Source
Keep the original workbook restricted while giving dashboard users access only to approved data.
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.

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.





