Function IMPORTRANGE is not updating

Question

I want to use the IMPORTRANGE function every time I open one spreadsheet so this opened spreadsheet can be synchronized with another spreadsheet. So, in A1, I put a call formula like this:

=importrange("0AmEr9uNtZwnNdDFKMTVlbmZYZ3ZyOWM0aXpZS2twM1x";  "myData!A1:W384")

But this IMPORTRANGE call remains static. That is, once imported, the data isn't updated when the imported sheet is changed.

So what is wrong? I wonder if I can use IMPORTRANGE, a spreadsheet function, within a Google Apps Script (which is like JS code).

How can I call a spreadsheet function inside a script?

I think there is a answer to a similar question here: stackoverflow.com/questions/11143684/… . So, there's no way to use specifically the importrange(). I have to use range.getValues() and range.setValues(). — craftApprentice

Zig Mandel Zig Mandel · Accepted Answer · 2013-12-09T02:10:41

ImportRange does update automatically—just not instantly. Give it 5 minutes.

It won't update until you open the spreadsheet and
The one opening it must have "read" permission to the source.

If you really want to do it with code, use SpreadsheetApp.openById, getSheetByName, and getRange get/setValues.

Function IMPORTRANGE is not updating

1 Answers