How to Link Excel Workbooks in SharePoint (Step-by-Step Build)

Megan Bowen runs sales operations for our US regions. Every month, three regional managers update their own sales workbook, and she used to copy their totals into one summary by hand.

The answer is a workbook link: a formula in one Excel file that reads a cell from another file in the same SharePoint library.

In this tutorial, I’ll show you how to link Excel workbooks in SharePoint with Excel for the web, keep the links refreshing, and repair one after a source file is renamed.

Here’s what we’re building, a summary that pulls October and November 2026 totals from three regional files:

Sales Summary workbook in Excel for the web showing linked East, West and Central region totals for October and November 2026

Before You Start

You need edit rights on the library and on every workbook. Both files must be Excel workbooks saved in SharePoint or OneDrive that your Microsoft 365 account can open. New to libraries? Read what a SharePoint document library is first.

FileSheetWhat it holds
East Region Sales.xlsxSalesBoston, New York and Atlanta, total in row 5
West Region Sales.xlsxSalesSeattle, San Francisco and Denver, total in row 5
Central Region Sales.xlsxSalesChicago, Dallas and Minneapolis, total in row 5
Sales Summary.xlsxSummaryOne row per region, filled by links

Each source uses one layout. Here’s the East file:

CityOct 2026Nov 2026
Boston$48,200$51,750
New York$72,400$78,900
Atlanta$39,600$42,300
Total$160,200$172,950

Step 1: Put the Workbooks in One Library

  1. On your site, select New > Document library, name it ESP Excel Links, and select Create.
  2. Select Upload > Files and add the three regional workbooks and the summary.
ESP Excel Links document library with the regional sales workbooks and the Sales Summary workbook

I used PnP PowerShell. Use a team library, not a personal OneDrive, because links break when that person leaves. My OneDrive vs SharePoint comparison explains why.

Connect-PnPOnline -Url "https://<tenant>.sharepoint.com/sites/EnjoySharePoint" -ClientId "<your-app-id>" -Interactive
New-PnPList -Title "ESP Excel Links" -Url "ESPExcelLinks" -Template DocumentLibrary
"East Region Sales.xlsx", "West Region Sales.xlsx", "Central Region Sales.xlsx", "Sales Summary.xlsx" | ForEach-Object {
    Add-PnPFile -Path "C:\SPGuidesDemo\$_" -Folder "ESPExcelLinks"
}

Step 2: Type the Link Formulas

Open Sales Summary.xlsx from the library in the browser, not from a synced folder; my SharePoint sync vs add shortcut guide covers the difference.

  1. Select B2 and type an equals sign.
  2. Type the file’s web address in single quotes, with the file name in square brackets and the sheet name, then ! and the cell.
  3. Press Enter and repeat for the other five cells.

These are the six formulas in my summary:

B2  ='https://<tenant>.sharepoint.com/sites/EnjoySharePoint/ESPExcelLinks/[East Region Sales.xlsx]Sales'!$B$5
C2  ='https://<tenant>.sharepoint.com/sites/EnjoySharePoint/ESPExcelLinks/[East Region Sales.xlsx]Sales'!$C$5
B3  ='https://<tenant>.sharepoint.com/sites/EnjoySharePoint/ESPExcelLinks/[West Region Sales.xlsx]Sales'!$B$5
C3  ='https://<tenant>.sharepoint.com/sites/EnjoySharePoint/ESPExcelLinks/[West Region Sales.xlsx]Sales'!$C$5
B4  ='https://<tenant>.sharepoint.com/sites/EnjoySharePoint/ESPExcelLinks/[Central Region Sales.xlsx]Sales'!$B$5
C4  ='https://<tenant>.sharepoint.com/sites/EnjoySharePoint/ESPExcelLinks/[Central Region Sales.xlsx]Sales'!$C$5

The single quotes are required because the names contain spaces. You can also type = and select the cell in the source tab, but you’ll have to switch back yourself.

Formula bar in Excel for the web showing an external reference to the West Region Sales workbook

Microsoft’s other route: copy the source cell, then select Paste Special > Link to source in the summary.

Step 3: Trust the Workbook Links

Right after I typed the formulas, every linked cell showed #BLOCKED!. Excel treats links as unsafe until you trust them.

  1. In the yellow bar Trust workbook links?, select Trust Workbook Links.
Trust workbook links message bar in Excel for the web with linked cells showing BLOCKED errors

Checkpoint: the summary shows $453,500 for October and $483,050 for November, with East up 8.0%.

Step 4: Choose How the Links Refresh

Trusting the links opened the Workbook Links pane for me. You can also open it with Data > Queries & Connections > Workbook Links.

  1. On the Links tab, check that all three source files are listed.
  2. Open the Settings tab.
  3. Under Link refresh preferences, pick Always refresh links. The default is Ask before refreshing links.
Workbook Links pane in Excel for the web listing the Central, East and West Region Sales source workbooks

The preference is saved in the workbook for everyone. The trust bar still returned on every reopen until I turned on Always trust workbook links.

Workbook Links Settings tab with Always refresh links selected under Link refresh preferences

Test the Links

I opened the East file and changed Boston’s November number from $51,750 to $53,750. Excel for the web saves automatically.

When I reopened the summary and trusted the links, it refreshed on its own. East’s November total showed $174,950 (up 9.2%) and the grand total $485,050, with no formula edits.

Sales Summary after refresh showing the updated East November 2026 total of 174,950 dollars

Make It Production-Ready

  • Keep the source layout fixed. Inserting a row above the total moves the cell, and the link reads the wrong number.
  • Give each manager edit rights only on their own file. Unique permissions on a SharePoint library or file help here.
  • Back up the summary before you break a link. Breaking turns formulas into plain values, and it can’t be undone.

Troubleshooting

To see a broken link, I linked Link Test.xlsx to a copy of the West file, then renamed the copy. Excel showed UNABLE TO REFRESH, and the pane said Unable to get to file. The cell quietly kept its last value, $55,100.

Unable to refresh message bar in Excel for the web after the linked source workbook was renamed

The fix works right in the browser. In the pane, select the … next to the file, choose Change source, and pick the new file under Recent, Suggested or Browse.

Workbook Links pane menu with Change source highlighted for a source file that can no longer be found
  • The renamed file isn’t in search yet: search lagged right after my rename. Wait a few minutes, or edit the file name in the formula bar.
  • Links show $0 or blank: my script-built source files had no saved totals. Open the source in Excel, edit a cell so it saves, then refresh.
  • Old values after a fix: reload the tab. If Office keeps a stale copy, clear the SharePoint and Office cache.

Where to Take It Next

If the numbers need to land outside Excel, a flow can read an Excel file from SharePoint with Power Automate. And if the regional data should become a list, you can import Excel data into a SharePoint list instead.

More ways to work with files in SharePoint:

Frequently Asked Questions

Can Excel for the web link two workbooks in SharePoint?

Yes. Both files must be Excel workbooks stored online that your account can open. Microsoft lists the steps in Workbook links in Excel for the web.

Why do my linked cells show #BLOCKED!?

The workbook links aren’t trusted yet. Select Trust Workbook Links in the message bar, and the values load.

Do links break when I rename a file in SharePoint?

Yes. The cell keeps its last value and stops refreshing. Use Change source in the Workbook Links pane to point it at the new name.

Where is Edit Links in Excel?

The Workbook Links pane replaced it. In Excel desktop you can add the old Edit Links button back through Customize the Ribbon.