I'm not aware of a way to do that via the API, because you'd need to use a named range to not lose the reference to the cells. You can't currently create named ranges via the API, though.
Your best option might be to choose a naming scheme that does not rename old sheets, possibly by inserting a date into your sheet name. -Vic On Mon, Sep 26, 2011 at 8:11 PM, WillSh <[email protected]> wrote: > Hi, > > I have a spreadsheet that refers to various other sheets in my Google > Spreadsheet (refers to data1,data2 etc). Periodically a service will run, > rename existing data sheets via the API (data1_old, data2_old) and create > new data sheets, data1, data2 etc > > The difficulty is my sheet that refers to to data sheets now refers to the > renamed sheet (data1_old), not the new data_1 sheet and so on. > I know I can programatically insert a formula directly into the cell to > update this but i was wondering if there was another / easier way to prevent > the reference from being updated? > > Thanks, > Will >
