Error: This action would increase the number of cells in the workbook above the limit of 2000000 cel

[Adrian de Pedro]

Hi guys; how are you?

I'm working in a GA dashboard with google-analytics-spreadsheet-add-on in my sheets.

The error that it show me: This action would increase the number of cells in the workbook above the limit of 2000000 cells

Why happens that?

I have created only 45 reports, 45 "add on" calls.... and need show more relevant data in my panel.

Do you know some way to solve this problem?

Thanks.

Adrian

[Philip Walton]

I think Google Sheets has a limit of 2 million cells per spreadsheet, so that's probably what the error is. The only option is probably to break you spreadsheet up into multiple spreadsheets.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/847e9cce-4754-44af-94b6-efc784894984%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Adrian de Pedro]

Thanks Philip for your answer.

Is "one spreadsheets" the same that "new file" ??

I think so, but ¿Can i connect both spreadsheets to share data? ¿Can you tell me how to do?

Greetings

El viernes, 13 de noviembre de 2015, 19:02:35 (UTC+1), Philip Walton escribió:

I think Google Sheets has a limit of 2 million cells per spreadsheet, so that's probably what the error is. The only option is probably to break you spreadsheet up into multiple spreadsheets.

On Fri, Nov 13, 2015 at 5:47 AM, Adrian de Pedro <adepe...@gmail.com> wrote:

Hi guys; how are you?

I'm working in a GA dashboard with google-analytics-spreadsheet-add-on in my sheets.

The error that it show me: This action would increase the number of cells in the workbook above the limit of 2000000 cells

Why happens that?

I have created only 45 reports, 45 "add on" calls.... and need show more relevant data in my panel.

Do you know some way to solve this problem?

Thanks.

Adrian

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

[Philip Walton]

Take a look at the "Spreadsheet URL" configuration option to see how to export certain reports to different sheets.

https://developers.google.com/analytics/solutions/google-analytics-spreadsheet-add-on?hl=en#configuration-parameter-reference

On Fri, Nov 13, 2015 at 10:20 AM, Adrian de Pedro <adepe...@gmail.com> wrote:

Thanks Philip for your answer.

Is "one spreadsheets" the same that "new file" ??

I think so, but ¿Can i connect both spreadsheets to share data? ¿Can you tell me how to do?

Greetings

El viernes, 13 de noviembre de 2015, 19:02:35 (UTC+1), Philip Walton escribió:

I think Google Sheets has a limit of 2 million cells per spreadsheet, so that's probably what the error is. The only option is probably to break you spreadsheet up into multiple spreadsheets.

On Fri, Nov 13, 2015 at 5:47 AM, Adrian de Pedro <adepe...@gmail.com> wrote:

Hi guys; how are you?

I'm working in a GA dashboard with google-analytics-spreadsheet-add-on in my sheets.

The error that it show me: This action would increase the number of cells in the workbook above the limit of 2000000 cells

Why happens that?

I have created only 45 reports, 45 "add on" calls.... and need show more relevant data in my panel.

Do you know some way to solve this problem?

Thanks.

Adrian

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/847e9cce-4754-44af-94b6-efc784894984%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/2581890b-4570-42b5-9620-e63de90bccdc%40googlegroups.com.

[Adrian de Pedro]

Really thanks.

I need to test this but i think is a correct way to solve my problem and optimize my Spreadsheet.

Grettings

El viernes, 13 de noviembre de 2015, 19:26:20 (UTC+1), Philip Walton escribió:

Take a look at the "Spreadsheet URL" configuration option to see how to export certain reports to different sheets.

https://developers.google.com/analytics/solutions/google-analytics-spreadsheet-add-on?hl=en#configuration-parameter-reference

On Fri, Nov 13, 2015 at 10:20 AM, Adrian de Pedro <adepe...@gmail.com> wrote:

Thanks Philip for your answer.

Is "one spreadsheets" the same that "new file" ??

I think so, but ¿Can i connect both spreadsheets to share data? ¿Can you tell me how to do?

Greetings

El viernes, 13 de noviembre de 2015, 19:02:35 (UTC+1), Philip Walton escribió:

I think Google Sheets has a limit of 2 million cells per spreadsheet, so that's probably what the error is. The only option is probably to break you spreadsheet up into multiple spreadsheets.

On Fri, Nov 13, 2015 at 5:47 AM, Adrian de Pedro <adepe...@gmail.com> wrote:

Hi guys; how are you?

I'm working in a GA dashboard with google-analytics-spreadsheet-add-on in my sheets.

The error that it show me: This action would increase the number of cells in the workbook above the limit of 2000000 cells

Why happens that?

I have created only 45 reports, 45 "add on" calls.... and need show more relevant data in my panel.

Do you know some way to solve this problem?

Thanks.

Adrian

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/847e9cce-4754-44af-94b6-efc784894984%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

[Amit Chatrath]

something similar happened to me.  Best is open the results sheets and delete all the blank cells. I am running 115 report in 1 sheet and it works fine after deleting blank cells.

[Ryan Praskievicz]

Hi Adrian,

I've dealt with the 2 million cell limit with Google Analytics Sheets before. The solution I came up with (as Amit also mentioned in the thread) was to delete blank columns and rows. Here is a sample Google Sheet with a script to automatically Delete Blank Columns and Delete Blank Rows on all tabs in the sheet as well as a YouTube video that walks through how to use the scripts.

Sample Google Sheet
YouTube Video Tutorial

Best,

Ryan Praskievicz

@ryanpraski

[Adrian de Pedro]

Thanks Amit, thanks Ryan, it's true that was the problem. I've tested now and i can do more reports.

:)

[Lloyd Martin]

Perfect...I just went to the right of the last column I was using on each spreadsheet and clicked and dragged right, then deleted all those rows.

[Arnaud Mathieu]

Thank you Ryan, your script effectively solved my problem.

[rfre...@ylopo.com]

ff