Error: This action would increase the number of cells in the workbook above the limit of 5,000,000 cells

This short guide talks about the error message "Error: This action would increase the number of cells in the workbook above the limit of 5,000,000 cells" and tells you how to work around it.

Google Sheets imposes some limitations on how much data you can have in a single Spreadsheet. This error message means that your sheet (the whole file) has so many cells populated with data that the new query results would push the populated cell number over that limit, and for this reason, the query is aborted.

To work around this, create and run the query in a new file, or remove unnecessary data from the current file to make more space for new data.

How to remove cells?
Simply choose the unnecessary columns and delete them. Then repeat the same for the unnecessary rows.
You can always add more columns and rows if needed. If by accident you remove columns or rows that had data you needed, go to File --> Version history --> See version history, and find & restore a working version.

TIP:
Google Sheets counts even empty cells towards this limit, so a good trick to get more data to your Sheet is to remove unnecessary rows & columns from tabs where you do not need them.

More information here (check "Spreadsheets"):
https://support.google.com/drive/answer/37603

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.