Data Import & Export

Excel Online: Link SharePoint Workbooks When Get Data Is Missing

Emma BrownEmma Brown Nov 14, 2026 868 views

Question details

The user wants to link cells between SharePoint workbooks when the Get Data icon is unavailable in Excel Online.

How to Link SharePoint Workbooks When Get Data Is Missing in Excel Online
Product
Excel for the web and SharePoint
Device & OS
not provided
Scenario
The user wants one SharePoint workbook to display values from another workbook.
Observed behavior
The Get Data icon is missing, and external links created in desktop Excel may be disabled or fail to update when opened in SharePoint.
Before you start

Check that you can open both SharePoint workbooks and have permission to access the source file. If you plan to use desktop Excel, confirm that it is installed and signed in to the account that can access the files.

Solution 1Recommended

Create the Workbook Link in Desktop Excel

Use desktop Excel to create a cell reference when the required linking controls are unavailable in Excel for the web.

Get Data is an import feature; a cell-to-cell workbook link is created with a formula. Excel for the web supports some workbook-link operations, but availability and refresh behavior can vary by feature, account, permissions, and security settings.

1
Open both workbooks

In SharePoint, open the source workbook and destination workbook, then choose Open in app or Open in Desktop App for each file.

2
Create the reference

In the destination workbook, select the cell where you want the value and type =. Switch to the source workbook, select the source cell, and press Enter.

3
Save and check the link

Save the destination workbook, reopen it in Excel for the web, and check whether the value appears. If prompted, review and enable or trust workbook links only when you trust the source.

Create the Workbook Link in Desktop Excel
Web refresh may differ: Creating a link in desktop Excel does not guarantee that it will refresh in the browser. Check source-file permissions and any workbook-link or security prompts in Excel for the web.
Free Microsoft Office alternative

Work With Excel Files in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet for an easy transition, though WPS does not fix missing Excel Online features or SharePoint link settings.

Open and edit compatible Microsoft Excel XLSX and XLS filesWork with formulas and references in a familiar spreadsheet interfaceUse a free, lightweight office suite for everyday spreadsheet tasksMove between compatible Office files without learning an entirely new interface
QA img-9

Frequently Asked Questions

Why is Get Data missing in Excel Online?

Get Data availability can depend on the Excel for the web feature set, your account, license, and organization settings. Check the Data tab and ask your Microsoft 365 administrator if the expected controls are unavailable.

Do I need Get Data to link one cell to another workbook?

No. Get Data is used for importing data. In desktop Excel, you can create a workbook reference by typing = in the destination cell and selecting a cell in the open source workbook.

Why does my external link not update in SharePoint?

The source may be inaccessible, the link may need to be trusted, or the link's refresh behavior may differ in the browser. Open both files to check permissions, review any workbook-link prompts, and test the link in desktop Excel.

Can I link cells on different sheets in Excel for the web?

Yes. In the destination cell, type =, select the source worksheet tab, click the source cell, and press Enter.

Will a Microsoft 365 desktop license guarantee that links refresh online?

No. A license that includes desktop Excel may let you create the link there, but browser refresh also depends on supported features, permissions, and security settings.