File Sharing Problems

How to Link Excel Workbooks Stored on the Same SharePoint Site

Phi Hung VoPhi Hung Vo Nov 13, 2026 869 views

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.

How to Link Excel Workbooks Stored on the Same SharePoint Site
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

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.

Solution 1Recommended

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.

1
Open both SharePoint workbooks

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.

2
Copy the source table or range

In the source workbook, select the table or range you want to link, then press Ctrl+C or click Home > Copy.

3
Select the destination cell and open Paste Special

In the destination workbook, click the target cell, then go to Home > Paste > Paste Special or right-click and select Paste Special.

4
Choose Paste Link

In the Paste Special dialog, click Paste Link and then OK to create a link to the copied SharePoint workbook range.

Availability depends on your Excel version and SharePoint setup: If Paste Link is unavailable, confirm that both files are in a supported SharePoint document library, that you have Edit or Contribute permission, and that your Excel update channel supports this feature.
Free Microsoft Office alternative

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.

Opens and saves Excel .xlsx files while preserving formulas, tables, and data ranges.Familiar ribbon-style interface makes switching from Microsoft Excel easier.Free and lightweight Office suite with Spreadsheets, Writer, and Presentation.Lets you edit and recalculate linked workbook values locally without Microsoft 365 SharePoint restrictions.
microsoft office alternative - wps office

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.