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?