0

Hi I have linked objects in Google slides that come from sheets and I want it to automatically update the objects when a change is made in sheets. There are countless websites saying it's easy: tools > linked objects > update all. But this is not automatically done. I really need it to automatically update. They say it can be done with scripts but haven't found a script that works.

Here's the latest script that I was found but still, it's not updating automatically

function refreshChartsOnChange(){
    var getSlides = SlidesApp.openById('SLIDE-ID').getSlides();

    for (var i = 0; i < getSlides.length; i++) {
        var slide = getSlides[i];
        var sheetCharts = slide.getSheetsCharts();

    for (var j = 0; j < sheetCharts.length; j++) {
        var sheetChart= sheetCharts[j];
        sheetChart.refresh();
    }
}

I really need this and PLEASE do not tell me to manually go through the menu and press the 'update all' as this is useless to me for my needs. Thanks.

Improve this question
2
  • I haven't used slides much. Have you tried attaching your function to an installable onEdit() trigger for the Spreadsheet that contains the source objects? You may wish to add more logic so that it only triggers when the appropriate sheets are edited Commented Jun 25, 2023 at 18:17
  • Does this answer your question? Apps script newbie question: Can you automate the Tools > Linked objects > Update all command? Commented Jun 27, 2023 at 12:55
Related questions
3
Auto-update all linked objects in google slides on open
2
Automatically Updating a Google Sheets Table inside Google Slides
0
Is there a way in which I can automatically update a table in google slides linked to google sheets without clicking update?
Load 2 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.