I have set up three reports to generate overnight and create 3 .csv files

I have created a spreadsheet where these csv files are read by the data model and from there, create power pivot tables.

The requirement is that the pivot tables read the most current data whenever they are opened - they are all protected but slicers are active as they are to be used by all members of the school.

After much watching of you-tube and hours of googling I have found two places where ticks need to be added to update the data on opening. However, the data is still not updating when I open and I have to manually refresh (using a slicer also updates the data). This is fine for me, but as this spreadsheet is for all to use, it is important that it updates on opening.

The two places I have found to update on opening are:

On the Pivot table itself, right mouse click, Pivot Table Options, Data Tab, Refresh Data when opening the file - this screen appears to be the same as going via Analyze, Pivot Table Options

The other place is Data, Connections Properties and here you also get the chance to Refresh every 60 seconds as well as the Refresh when Opening - I've ticked both.

Is anyone aware of any other places that refresh on opening should be set please?