Fix Excel for the Web Filter Data Limit in a SharePoint Workbook
Question details
The user needs to filter a SharePoint workbook in Excel for the web without exceeding the supported data limit.

- Product
- Excel for the web and SharePoint
- Device & OS
- not provided
- Scenario
- Filtering a column in a SharePoint workbook with 375 rows and 64 columns.
- Observed behavior
- The workbook opens normally, but filtering a column displays an error that the view contains more data than currently supported.
Open the affected workbook from SharePoint and identify the column that triggers the error. You may need the desktop Excel app to inspect and edit named ranges in Name Manager.
Replace unnecessary OFFSET-based named ranges
Use this approach when filtering fails despite a relatively small worksheet; excessive OFFSET-based names may contribute to the error.
Open the workbook in desktop Excel and select Formulas > Name Manager.
Review the Refers to column for names that use the OFFSET function. Check where each name is used before changing it.
Select an OFFSET-based name that does not need to expand dynamically, choose Edit, and replace its Refers to formula with an appropriate fixed cell range, such as =Sheet1!$A$1:$A$375.
Save the workbook to SharePoint, reopen it in Excel for the web, and use the affected column's filter dropdown again.

Test a copy in another SharePoint location
Use a separate location to help determine whether the problem follows the workbook or is related to its original location.
Filter spreadsheets with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheets and use its filters while moving between office suites. It does not fix the SharePoint or Excel for the web error.

Frequently Asked Questions
Why does filtering fail when the workbook has only 375 rows?
The error may be related to workbook content beyond the visible row count, including excessive OFFSET-based named ranges. In desktop Excel, select Formulas > Name Manager to inspect them.
Where can I find OFFSET-based named ranges?
Open the workbook in desktop Excel, select Formulas > Name Manager, and look for OFFSET formulas in the Refers to column.
Can I replace every OFFSET formula with a fixed range?
Not necessarily. OFFSET may define a range that needs to expand or change. Check each name's uses and ensure a fixed range covers the required cells before replacing it.
What does testing the workbook in another SharePoint location show?
Open a copy in another SharePoint location and apply the same filter. If it fails in both places, the workbook may be involved; if only the original fails, compare the two locations and their settings.




