SharePoint Document Issues

Change Excel Link Sources in SharePoint Libraries

Algirdas JasaitisAlgirdas Jasaitis Nov 20, 2026 869 views

Question details

The user needs to change an Excel workbook link to a replacement file in a large SharePoint library.

How to Change Excel Link Sources in SharePoint Libraries
Product
Microsoft Excel and SharePoint
Device & OS
not provided
Scenario
A workbook links to another file in a SharePoint library, and the user needs to select a different source.
Observed behavior
The Change Source window displays the library, but metadata-based sorting or filtering does not reliably narrow the file list.
Before you start

In SharePoint, locate the replacement workbook and note its name and library folder. Make sure you have permission to open both the linked workbook and the replacement source.

Solution 1Recommended

Locate the replacement workbook and change the Excel link

Use SharePoint to identify the file first, then navigate to it in Excel's Change Source window.

The Change Source window may not offer reliable filtering by SharePoint metadata. Searching or sorting in the library can help you identify the replacement before opening the file picker.

1
Find the replacement file

Open the SharePoint document library in your browser. Use the library search, available views, or folder navigation to find the replacement workbook and note its exact name and location.

2
Open workbook links

Open the linked workbook in Excel and select Data > Edit Links. In versions with the newer interface, select Data > Workbook Links instead.

3
Change the source

Select the existing source and choose Change Source. Navigate to the SharePoint library and folder, select the replacement workbook, and confirm the selection.

4
Check the linked values

Review cells that use the link and update the links if Excel prompts you. Save the workbook after confirming that the expected values appear.

Locate the replacement workbook and change the Excel link
Large library limitation: Search or metadata sorting in the Change Source window may not narrow a large library effectively. Smaller folders or libraries can make files easier to locate, but check existing links before moving source workbooks.
Free Microsoft Office alternative

Work with Excel-compatible spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and Excel format compatibility for an easier transition. It does not fix Excel's SharePoint Change Source window or its metadata filtering limitation.

Open and edit Excel-compatible XLS and XLSX filesWork with spreadsheet formulas and linked dataUse a familiar interface for everyday spreadsheet tasksMove between Office documents with support for common Microsoft formats
microsoft office alternative - wps office

Frequently Asked Questions

Where do I change a linked workbook in Excel?

Open the dependent workbook and select Data > Edit Links, or Data > Workbook Links in versions that show the newer interface. Select the source and choose Change Source.

Can I filter the Change Source window by SharePoint metadata?

The window may display metadata sorting options, but it does not provide a reliable metadata-based filtering method for locating files. Find the replacement in the SharePoint library first and note its name and folder.

How can I find a replacement file in a large library?

Open the SharePoint library in a browser and use its search, available views, or folder structure to identify the workbook. Then navigate to that location in Excel's Change Source window.

Will moving source workbooks into smaller folders affect existing links?

It can affect links because the source location changes. Check existing workbook links before moving files, and use Data > Edit Links or Data > Workbook Links to update any affected sources.