Fix Excel Advanced Filter Resource Errors with Merged Cells
Question details
Resolve an Excel Advanced Filter resource error when the criteria worksheet contains merged cells and the filter uses an external dynamic named range.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Running Advanced Filter with an external dynamic named range and a criteria worksheet containing merged cells, potentially after an Office update.
- Observed behavior
- Excel reports that it has run out of resources when the filter is run.
Identify the Advanced Filter list and criteria ranges, including any external workbook used by the dynamic named range. If the external workbook is closed, open it before testing and note your installed Office version and update channel.
Unmerge the criteria sheet and check the named range
Start here when merged cells on the criteria worksheet may be triggering the resource error.
On the criteria worksheet, select the merged cells, including any near the criteria range, and choose Home > Merge & Center > Unmerge Cells.
Review the criteria range and confirm it includes column headers and at least one row containing the intended criteria. Reenter any values that were lost when cells were unmerged.
Open Formulas > Name Manager, select the dynamic named range, and check its Refers to formula and external workbook reference.
Go to Data > Advanced, confirm the List range and Criteria range, and select OK to test the filter.

Check the Office version and install updates
Use this when the error began after an Office update or may be specific to a version or update channel.
Test Excel and available system resources
Try these checks if unmerging cells and updating Office do not resolve the error.
Work with filtered spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheets. It supports common Excel formats to make moving existing files easier, though it does not fix Microsoft Excel resource errors.

Frequently Asked Questions
Why should I unmerge cells on the criteria worksheet?
Merged cells on the criteria worksheet may be associated with this version-specific resource error. Select them and use Home > Merge & Center > Unmerge Cells, then rerun the filter to see whether it helps.
Where can I find my Office version and update channel?
In Excel, open File > Account and look under Product Information for the version, build, and update channel.
How do I check the external dynamic named range?
Open Formulas > Name Manager, select the name, and inspect its Refers to formula. Check that the external workbook reference is correct and open the source workbook before retesting.
Does Excel Safe Mode fix the filter error?
Safe Mode is a diagnostic test, not necessarily a fix. On Windows, run excel /safe from Windows+R; if the filter works there, review add-ins under File > Options > Add-ins.
Will installing 64-bit Office guarantee a fix?
No. The 64-bit edition can help with memory-intensive workbooks, but this error may also depend on merged cells or the Office version. Check compatibility with your add-ins before changing editions.




