Google-sheets – Google Sheet “across spreadsheets you’ve created”

google sheetsimportdata

I have an error for an importdata function

Error
Loading data may take a while because of the large number of requests. 
Try to reduce the amount of IMPORTHTML, IMPORTDATA, IMPORTFEED or 
IMPORTXML functions across spreadsheets you've created.

Does Google Sheet mean the number of functions across the current workbook? Or all workbook that I have ever created in Google Sheets?

Best Answer

Across all the sheets you have created. I have run into this same issue before. this includes test sheets youve played with etc. anytime you have added those import functions and not removed them or left them in a state where they will not try to refresh on their own.

Related Solutions

Google Sheets – Non-Deterministic Parameters to Custom Function

I've made some research and it seems like an old problem, even from old MS Excel versions.

I think the best/easiest way is to create your own randomization function. This way random value won't be regenerated. You use it the same way as before =plusOne(myRandom())

function plusOne(i) {
  return i + 1;
}

function myRandom() {
  # Some function
  return Math.random();
}

You could also shorten it =myRandom()

function myRandom() {
  # Some function
  return Math.random() + 1;
}

Google Sheets ArrayFormula – Find Previous Non-Empty Cell and Last Row

Can't edit your spreadsheet, but this formula (entered in C3)

=ArrayFormula(if(row(B3:B) <= max(if(not(isblank(B3:B)), row(B3:B))),vlookup(row(B3:B),filter({row(B3:B),B3:B},len(B3:B)),2),))

should bring you the output you expected.

Best Answer

Related Solutions

Google Sheets – Non-Deterministic Parameters to Custom Function

Google Sheets ArrayFormula – Find Previous Non-Empty Cell and Last Row

Related Topic