Hi,
I have this report based on 11 Google sheets as my data sources. I would like to be able to replace these sheets in the folder they reside with updated files. I found out that when I do this the report doesn’t show the updates, but rather the data remains the same. In order to update the report I have to make the changes directly in the Google sheets, which is a bummer because there are 11 of these. Is there a way to bypass this? Why can’t I simply replace the Google sheets? Is there something I am missing or should be able to do in order to accomplish this? Thanks.