I have created a Google document that links to tables in a Google spreadsheet.

Now I want to copy both the spreadsheet and the document.

However, the link remains to the original spreadsheet.

Where can I set the filename of the copy of the spreadsheet?

  • in the spreadsheet, you need to look for import formulas like =IMPORTRANGE() where you need to change URL or ID

    enter image description here

  • in the document, you need to look for link menu appearing on the top right of your imported table and by selecting change range you can change the source

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.