QuickBooksHelpIntuit
Fix a report that is too large to display
by Intuit•2• Updated 3 days ago
Learn how to fix a report that is too large to display in QuickBooks Online.
While running reports, you may see a message that says your report is too large to display. This happens when the report exceeds the size limits. Here’s how you can fix this.
Some of your reports will look different depending on whether they're in the classic view or new enhanced experience. Learn more about the new enhanced experience. |
Understand size limits when exporting a report to Excel
- Columns: maximum of 1,024
- Cells: maximum of 400K cells with data
- Data: maximum of 10 MB
Fix a report that is too large to display
Here are ways to fix a report that is too large to display.
- Go to Reports (Take me there).
- Open the report you want to fix.
- Drag the vertical line between the columns to adjust their width.
- Remove columns to display more data.
- Run reports for a specific date range using the Report period ▼ dropdown.
Note: If the report still doesn’t display all your data, you can export your reports to Excel.
Remove columns
- Sign in to QuickBooks Online.
- Select Reports.
- Open the report you want to view and edit.
- Select Columns. Uncheck the box of the column you want to remove.
- Select Save As, then select Save. The report is saved under custom reports.
Learn more about customizing reports in QuickBooks Online using modern view.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Fix "The report you are attempting to create may not display..." in QuickBooks Onlineby QuickBooks•63•Updated September 12, 2024
- Troubleshoot printing in QuickBooks Desktop for Macby QuickBooks•3•Updated 1 year ago
- Troubleshooting Images in Emailsby QuickBooks•Updated 1 week ago
- Install and use QuickBooks Advanced Reportingby QuickBooks•15•Updated 1 year ago