<CustomViewFailing: Cant Push Objects - Large Excel Spreadsheets]
Introduction
In this article, we will discuss the issue of custom view failing to push objects in large Excel spreadsheets, specifically when using Microsoft 365 Apps Enterprise. This problem often occurs when the spreadsheet has a considerable number of sheets, and the user wants to view only a few of them.
Understanding the Problem
When working with large Excel spreadsheets, users may encounter the error message “Custom view failing to push objects” when they attempt to change the view to display only a specific sheet. This message is particularly common when dealing with spreadsheets that have many sheets (e.g., 50+) but only a small amount of data in each sheet (e.g., 28 rows x 9 columns).
Why Does This Problem Occur?
The issue arises due to a limitation in Excel's custom view feature. The custom view feature is designed to save and restore the current state of the workbook that is open, including the visible range of the sheets, column widths, filter settings, and more. However, it is not optimized for large spreadsheets with many sheets. As a result, when Excel attempts to push the objects in the large spreadsheet, it encounters performance issues and can't complete the task, leading to the error message mentioned above.
Possible Solutions
While the issue cannot be resolved entirely, there are a few possible solutions that can help alleviate the problem.
Limit the Number of Sheets
One possible solution is to limit the number of sheets in the workbook. Users can consider removing any unnecessary sheets or consolidating data into fewer sheets. This approach can make it easier for Excel to push the objects and reduce the likelihood of encountering the custom view failure error message.
Use Named Ranges
Another alternative is to use named ranges instead of displaying entire sheets. Named ranges are a way to define a specific section of a sheet or a range of cells. By using named ranges, users can display only the important data in their custom views, reducing the number of objects that Excel needs to push.
Create a New Workbook
Users can also consider copying the relevant sheets to a new workbook and then create custom views for the new workbook. This approach can help alleviate the performance issues that can cause the custom view failure error message.
Use Other Viewing Options
Users can consider using other viewing options in Excel, such as the Page Layout view or the Reading View. These options may be more suitable for displaying large spreadsheets with many sheets.
- The custom view feature in Excel is not optimized for large spreadsheets with many sheets, leading to the custom view failing to push objects error.
- Possible solutions include limiting the number of sheets, using named ranges, creating a new workbook, and using other viewing options.
References
- Microsoft Support. (2021). Excel custom views not working. https://support.microsoft.com/en-us/office/excel-custom-views-not-working-88359c8b-0201-4600-8a33-90b06451c374
- Exceljet. (2021). Use named ranges in Excel. https