How do I overwrite or replace a sheet which is linked with multiple reports/reference sheets etc,.

Dhanush

I have a master data file which has around 20000 rows with nearly 10 columns (200000 Cells) Data driving several reports (50~60), reference formulas to several sheets (8~10). Master Data file changes (200000 Cells) everyday (Adds/Removes/Re-arranges data). In excel, we just save the file under the same name and it gets overwritten and the data will flow to all linked/referenced documents. But I think smart sheet is ruled by a sheet ID (Not editable) and can be saved with the same file name. Hence, the links still flow from the old outdated master data sheet. How do I either change the sheet link in all report and referenced file in one shot or how do I reference the updated master data file as same as the old master data file.

Lucas Rayala

https://community.smartsheet.com/discussion/122563/how-do-i-overwrite-or-replace-a-sheet-which-is-linked-with-multiple-reports-reference-sheets-etc

I usually use the API to handle a job like this, but if you are doing it manually, you can upload the new excel using the excel import, delete the contents of the master sheet, then use an automation to copy the rows of the new sheet into the master. The automation may gack when moving that many rows, you’ll want to test it.

Lucas Rayala

https://community.smartsheet.com/discussion/122563/how-do-i-overwrite-or-replace-a-sheet-which-is-linked-with-multiple-reports-reference-sheets-etc

I usually use the API to handle a job like this, but if you are doing it manually, you can upload the new excel using the excel import, delete the contents of the master sheet, then use an automation to copy the rows of the new sheet into the master. The automation may gack when moving that many rows, you’ll want to test it.

Lucas Rayala

if you want the Python code for the API I can link you to the GitHub