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.

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.