In google slides you can have linked objects which is a chart or a range in sheet that you can view in slides. If you change the chart or the range in sheets then you can click update in slides and you will be able to see the changes.
The problem is that I can't find a way to change which sheet the linked object points to. So if I have a table in slides that is linked to a range in one sheet, how do I change it to link to another sheet?
The reason I want to be able to change the linked object form one sheet to another is so it is possible to make a template for google slides and a template for a google sheet. Then when you want to make a new instance of the templates then you are able to change the linked objects in the new google slides instance to point to the new instance of the google sheet document.
I work in a company where we make a lot of google slides reports based on google sheet data.
I have tried looking through the different interface in google slides and it seems like this is not possible.
Now if there is a way to be able to fix this using google scripts then that would also work. I know how to code in javascript and have worked have made some scripts in google scripts before. If it is possible to do without coding then that would be amazing since it would be much easier to set it up for people in our business.
