Excel Online: Link SharePoint Workbooks When Get Data Is Missing
Question details
The user wants to link cells between SharePoint workbooks when the Get Data icon is unavailable 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.
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.
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.
In SharePoint, open the source workbook and destination workbook, then choose Open in app or Open in Desktop App for each file.
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.
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.

Sync the SharePoint Folder and Link Local Copies
Use OneDrive sync if opening the SharePoint files directly in desktop Excel is not practical.
Link Sheets Within the Same Workbook
Use a worksheet reference if the source and destination can be kept in one workbook.
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.

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.




