https://drive.google.com/file/d/[FILE_ID]/view?usp=sharing
http://drive.google.com/uc?export=view&id=[FILE_ID]
=IMPORTDATA("http://drive.google.com/uc?export=view&id=[FILE_ID]")
function forceRefreshSheetFormulas(sheetName) { var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var sheet = activeSpreadsheet.getSheetByName("Lapa1"); var range = sheet.getDataRange(); var numCols = range.getNumColumns(); var numRows = range.getNumRows(); var rowOffset = range.getRow(); var colOffset = range.getColumn(); // Change formulas then change them back to refresh it var originalFormulas = range.getFormulas(); //Loop through each column and each row in the sheet //`row` and `col` are relative to the range, not the sheet for (row = 0; row < numRows ; row++){ for(col = 0; col < numCols; col++){ if (originalFormulas[row][col] != "") { range.getCell(row+rowOffset, col+colOffset).setFormula(""); } }; }; SpreadsheetApp.flush(); for (row = 0; row < numRows ; row++){ for(col = 0; col < numCols; col++){ if (originalFormulas[row][col] != "") { range.getCell(row+rowOffset, col+colOffset).setFormula(originalFormulas[row][col]); } }; }; SpreadsheetApp.flush(); };
Here is a helpful tutorial for setting up script on Google Sheets
Total delay is 30sec - 1,5min