• Register
0 votes

Problem :

I am getting below google sheet error
this action would increase the number of cells in the workbook above the limit of 2000000 cells.
6.9k points

1 Answer

0 votes

Solution :

According to the Files you can store in Google Drive Google Sheets has the 5 million cells limit by spreadsheet. 

I myself tested the above scenario by trying to insert a 1,999,999 columns to the spreadsheet that contains a single sheet with a single cell (A1) by using the below script:

function testCol() {
  SpreadsheetApp.getActiveSheet().insertColumns(1, 1999999)
36.1k points

Related questions

0 votes
2 answers 28 views
Problem: You use this method to determine the number of items stored in an ArrayList object?
asked Apr 18 ArifulIslam 5.4k points
0 votes
1 answer 62 views
Problem : java does not limit the number of dimensions that an array may have
asked Nov 1, 2019 peterlaw 6.9k points
0 votes
1 answer 21 views
Problem : I am currently facing below error in my iPhone: “The maximum number of free accounts have been activated on this iPhone”. To fix this problem I even tried to erase all content and settings of the iPhone and after that set it as the fresh new iPhone. But I am still facing the above problem. How can I fix my iPhone now?
asked Feb 28 mphil 2.3k points
0 votes
1 answer 2 views
Problem: In general, for which of the following would you want to use lossless compression? -A log file -A movie -A JPEG image -An mp3 audio file -An encrypted email
asked Jul 21 HenryL 620 points
0 votes
1 answer 17 views
Problems: Can anyone give the right solution? In which of the following situations would restoring from a backup be the best option? (Select Two.) A. You need to restore several word processing files that were accidentally deleted from My Documents. B. You recently ... a new application and now the system behaves erratically. E. You need to restore a Windows system after a hard drive failure.
asked Feb 14 maddi86 5.4k points