Change Excel Link Sources in SharePoint Libraries
Question details
The user needs to change an Excel workbook link to a replacement file in a large SharePoint library.

- 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.
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.
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.
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.
Open the linked workbook in Excel and select Data > Edit Links. In versions with the newer interface, select Data > Workbook Links instead.
Select the existing source and choose Change Source. Navigate to the SharePoint library and folder, select the replacement workbook, and confirm the selection.
Review cells that use the link and update the links if Excel prompts you. Save the workbook after confirming that the expected values appear.

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.

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.




