Forum Discussion

NirGr's avatar
NirGr
Copper Contributor
May 23, 2023

linking excel workbooks in the same SharePoint

Hi as explained in Microsoft data knowledge I tried to make connection between excel table workbook to new excel workbook both of them in the same SharePoint.  the option copy and paste as connecti...
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
May 23, 2023

NirGr 

To establish a connection between two Excel workbooks in SharePoint, you can follow these steps:

  1. Open both the source workbook (containing the data you want to link) and the destination workbook (where you want to create the link).

  2. In the source workbook, select the range of cells or table that you want to link to the destination workbook.

  3. Copy the selected cells by pressing Ctrl+C or right-clicking and choosing "Copy."

  4. Switch to the destination workbook.

  5. In the destination workbook, select the cell where you want the linked data to appear.

  6. Right-click the selected cell and choose "Paste Special."

  7. In the Paste Special dialog box, choose the "Paste Link" option. This should create a link to the source data.

  8. Click "OK" to complete the linking process.

Note: The availability of the "Paste Link" option may vary depending on the version of Excel and the specific settings of your SharePoint environment. Ensure that you have the necessary permissions to access and modify both workbooks in SharePoint.

If the "Paste Link" option is disabled or unavailable, it could be due to limitations or restrictions set by your SharePoint administrator. In that case, you may need to consult with your SharePoint administrator or IT department for assistance in enabling this feature.

Additionally, make sure that both workbooks are stored in a SharePoint document library that allows linking and that you have appropriate permissions to access and modify the files.

Resources