• Register
0 votes
161 views

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 5 3
6,930 points

Please log in or register to answer this question.

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)
}
9 7 4
38,600 points

Related questions

1 vote
1 answer 4 views
4 views
Problem: I have a Google Sheets workbook with more than 70 tabs. I want to Linking to another tab in Google Sheets. Please help me to link it. Thanks.
asked Mar 27 Shovo210 14k points
0 votes
1 answer 6 views
6 views
Problem: How do I limit the number of rows returned by an Oracle query after ordering? please help.
asked Mar 10 ummesalma 25.2k points
0 votes
2 answers 6 views
6 views
Problem: I used Google to try to find a solution on the web of the above question, But I got no useful hints. Can I get Pointer information about my problem with this?
asked Mar 21 shamimkhan 15.1k points
0 votes
1 answer 3 views
3 views
Problem: I will request someone to answer my question Please, I have searched on the web but I got no useful information for this, now I am in difficulty continuing my learning
asked Mar 21 rubelkhan 20.4k points
0 votes
1 answer 5 views
5 views
Problem: What are my options for resolving this problem: Cannot run the macro the macro may not be available in this workbook or all macros may be disabled
asked Apr 5 tuhin1 48.9k points
0 votes
1 answer 1 view
1 view
Problem: anyone who know this problem please help? is there a limit on the number of email recipients in gmail
asked Apr 6 Rohit kr 16.2k points
0 votes
1 answer 1 view
1 view
Problem: Can anyone tell me the solution of this problem? How to limit the number of decimal places in java?
asked Apr 3 Ifra 24.4k points
0 votes
1 answer 17 views
17 views
I am new to this. I just want to know how to do that?
asked Nov 30, 2020 TeamScript 13.5k points
0 votes
1 answer 99 views
99 views
Problem : java does not limit the number of dimensions that an array may have
asked Nov 1, 2019 peterlaw 6.9k points
1 vote
1 answer 2 views
2 views
Problem: Can anyone tell me the solution of this problem? how to limit number of decimal places in java
asked Apr 7 MUHAMMAD MUNEEB 83k points