Google Drive Spreadsheet Keys -

have multiple references other google drive spreadsheets using importrange spreadsheet key. reason spreadsheet keys appear have changed, can find no way prevent happening or make importrange statements update automatically.

this leaves me having search out , open referenced spreadsheets, copy new key , paste every importarange statement correct it.

does 1 know way around or how protect against it. 1 know why spreadsheet keys may have changed?

also there not clear context, spreadsheet referring to. 1 know how might find out seeing key has changed.

the reason spreadsheet key has been changed sheets updated new sheets. can check checking starting character value of spreadsheet key. if value 0, old sheet , if 1, new sheet.

the way can changed sheet old key finding sheet in drive spreadsheet key , give new sheet. may can add old key in sheet url , redirect actual sheet new key.

hope helps!