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
