This has been disabled in the new sheets which you may likely have been
converted to. I use the script below to accomplish the same thing:
// to be used in the spreadsheet like ImportRange,
// i.e. like this: =myImportRange( "key" ; "sheet!range" ; GoogleClock() )
// the third parameter - GoogleClock() - triggers an automatic update every
minute.
// updated 2011-07-17 (ahab): better regex to strip sheetname of *outer*
single quotes
function myImportRange(key ,sheetrange) {
var shra = sheetrange.split("!") ;
if (shra.length==1) shra[1]=shra[0], shra[0]="";
var sheetstring = shra[0].replace( /^'(.*)'$/g , "$1") // was: replace(
/'/g , "") ; updated 2011-07-17 (ahab)
var rangestring = shra[1]
var source = SpreadsheetApp.openById( key )
if ( sheetstring.length==0 ) sheet = source.getSheets()[0] ;
else sheet = source.getSheetByName( sheetstring ) ;
return sheet.getRange( rangestring ).getValues();
}
On Saturday, October 25, 2014 5:17:09 PM UTC-5, Tyler Hueter wrote:
>
> I have been using drive for years now and am now having problems with the
> import range function. I have one sheet that pulls data from about 20 other
> sheets that are constantly changing. As of this week, this sheet will no
> longer update as the sheets are changed. After initially setting the range,
> the value in the cell will transfer to the new sheet but will not update.
> Is anyone else having this problem?
>
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
