How to Link Excel Workbooks Stored on the Same SharePoint Site
Question details
The user needs to link an Excel table or range between two workbooks stored on the same SharePoint site when the Copy and Paste as Connection option is unavailable.

- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- Connecting data between two Excel workbooks stored in the same SharePoint document library.
- Observed behavior
- The Copy and Paste as Connection command is unavailable or cannot be used, so an alternative method such as Paste Link is required.
Before you start, confirm that both workbooks are stored in a supported SharePoint document library and that your SharePoint account can access and edit both files. If Paste Link is grayed out later, check with your SharePoint administrator and verify your Microsoft 365 update channel.
Use Paste Special > Paste Link to Connect SharePoint Workbooks in Excel
Use this method when Copy and Paste as Connection is unavailable but you still need to connect a table or range between two Excel workbooks stored on the same SharePoint site.
This method uses Excel's Paste Link command to create a dynamic link from the source range or table into the destination workbook. It is the most direct workaround when the dedicated Copy and Paste as Connection command is not available.
In Excel, open the source and destination workbooks from the same SharePoint document library and confirm that you have permission to access and modify both files.
In the source workbook, select the table or range you want to link, then press Ctrl+C or click Home > Copy.
In the destination workbook, click the target cell, then go to Home > Paste > Paste Special or right-click and select Paste Special.
In the Paste Special dialog, click Paste Link and then OK to create a link to the copied SharePoint workbook range.
Check SharePoint Permissions and Microsoft 365 Update Channel When Paste Link Is Missing
Use this fallback when the Paste Link option does not appear or remains grayed out in Excel.
Need a Free, Lightweight Excel Alternative for .xlsx Workbooks?
WPS Office is a free, lightweight Office suite that opens, edits, and saves .xlsx workbooks with a familiar spreadsheet interface. It is a practical alternative when Microsoft 365 or SharePoint-specific linking features are unavailable or require update-channel changes.

Frequently Asked Questions
Why is Paste Link unavailable in Excel for SharePoint workbooks?
Paste Link may be unavailable if both workbooks are not stored in a supported SharePoint document library, your account lacks permission to edit both files, or your Microsoft 365 update channel does not expose the command. Confirm these items or contact your SharePoint administrator.
Can I link an entire Excel table or only a range?
You can link either an entire Excel table or a selected range. Copy the source table or range, select the destination cell, and use Home > Paste > Paste Special > Paste Link.
What permissions do I need to link Excel workbooks on SharePoint?
You need at least Edit or Contribute permission on both the SharePoint document libraries and the specific workbooks involved in the link.
Which Excel update channel supports the Paste Link feature?
Microsoft 365 Current Channel generally supports Paste Link for SharePoint workbooks. If you use a business subscription on Semi-Annual Channel, the feature may not be available until the tenant updates to a build that includes it.
Does WPS Office fix SharePoint workbook linking issues?
WPS Office is an Excel-compatible alternative for opening, editing, and saving .xlsx files. SharePoint-specific connection behavior is controlled by Microsoft 365 and SharePoint, so use Excel for SharePoint linking features or check Microsoft's update channel settings.




