Data Import & Export

How to Fix Excel Linked Files Not Refreshing After Adding Filters

Bushra Parveen Sep 30, 2026 869 views

Question details

External links between Excel workbooks stored in separate SharePoint teams stop refreshing automatically when worksheet or table filters are applied.

How to Fix Excel Linked Files Not Refreshing After Adding Filters

Product: Microsoft Excel, SharePoint
Device & OS: not provided
Scenario: Working with connected Excel workbooks across separate SharePoint teams where data is expected to sync automatically.
Observed behavior: Linked files update automatically until filters are added to the worksheet or an Excel table, at which point the automatic refresh fails.

Before you start

Before troubleshooting, ensure you have an active internet connection, proper access permissions to all linked SharePoint folders, and temporarily clear any active worksheet filters to verify if the links can update normally.

Solution 1Recommended

Verify Settings and Test Without Filters

Check file paths, permissions, and refresh settings, then test the workbook without active filters to isolate the root cause.

Often, automatic refreshing fails due to temporary syncing conflicts between Excel's internal filters and SharePoint's document management systems. Isolating the filters helps determine if the issue is a bug or a permissions error.

Clear active filters

Navigate to the 'Data' tab in the Excel ribbon and click 'Clear' in the Sort & Filter group to remove any active worksheet or table filters.

Verify data connections

Go to 'Data' > 'Queries & Connections' > 'Edit Links' (or 'Workbook Links' in newer Microsoft 365 versions) to ensure all source paths are correct and accessible.

Check refresh properties

Under 'Queries & Connections', click 'Properties' and verify that 'Refresh data when opening the file' or an automatic background refresh interval is checked.

Test the update

Save the workbook, close it, and reopen it without the filters applied to see if the external links refresh properly.

Verify Settings and Test Without Filters

Filter Context: Make sure you are checking the filters inside the Excel workbook itself (via the Data tab), not the document library filters on the SharePoint website.

Solution 2

Escalate to Microsoft 365 Administrator

If external links consistently fail only when Excel filters are active, the issue may require Microsoft support to review backend service logs.

Free Microsoft Office alternative

Experience Reliable Data Management with WPS Office

If Microsoft Excel external links keep failing due to complicated SharePoint syncing issues, consider using WPS Office. It provides a lightweight, highly compatible, and free alternative for managing complex spreadsheets, filtering data, and working with external files smoothly.

1. Install WPS Office: Download and install WPS Office for free from the official website.
2. Open Your Workbook: Launch WPS Spreadsheet and click 'File' > 'Open' to load your existing Excel files.
3. Manage Data Freely: Apply your data filters from the Data tab and manage your workbooks without unexpected background interruptions.

Seamlessly compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Reliable and powerful data filtering and sorting capabilities.Lightweight design for faster file loading, calculation, and processing.Familiar user interface with zero learning curve for easy migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel linked files stop updating in SharePoint?

This can happen due to permission changes, altered file paths, or specific service bugs where active worksheet or table filters interrupt the automatic data refresh mechanism between SharePoint environments.

How do I manually force external links to refresh in Excel?

You can manually refresh links by navigating to the 'Data' tab, clicking on 'Edit Links' (or 'Workbook Links'), selecting the linked source file from the list, and clicking 'Update Values'.

Are SharePoint document library filters the same as Excel worksheet filters?

No. SharePoint library filters are used to organize how files are displayed and sorted on the SharePoint website interface. Excel worksheet filters, accessed via the Data tab, are used to hide or show specific rows of data directly inside the spreadsheet itself.

Does using an Excel Table affect external link updates?

Normally, formatting data as an Excel Table should not prevent external links from updating. However, if table filters are actively applied to the data, certain known syncing issues in Microsoft 365 can cause external links to pause automatic refreshing until those filters are cleared.

Excel & Data Problems