I have Google Slides presentations I use as report templates with data in charts and tables linked to a Google Sheets document. In some cases I need to change the document that is the source for the data in the presentation while keeping the format the same (e.g. a new version of the spreadsheet).

Google Slides allows you to change the range for the data in the table, but not the document itself.

The only way I've seen so far to modify the source document for linked objects is with a script like the one proposed in this post.

The problem is that only works for linked charts, but not for tables. I'm trying to do the same for linked tables, but the issue I've ran into is that instead of working through ids like charts, tables work by defining a range in the linked sheet.

Does anyone have a solution to change the Sheets source for linked tables?

  • Hi. You said update the source for linked objects. Would you please edit your question to explain EXACTLY what you understand by this. I ask because UPDATE (within Slides) is a specific, well-documented, procedure.
    – Tedinoz
    Jan 12 at 2:44
  • Edited to clarify. It's changing the document that holds the data from one spreadsheet to another one, not updating the data in the table from the same source.
    – twalbaum
    Jan 12 at 22:15

Your Answer

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

Browse other questions tagged or ask your own question.