To set up scheduled refreshes in Excel, the file must be saved first to a OneDrive, OneDrive for Business, or a SharePoint drive location.
When you setup the scheduled refresh for the first time, we will ask you to authorise the access to one or more drives. This is done only once and you can use only one account. This account must have sufficient permissions to save files to the drive.
When creating scheduled refreshes for files, Supermetrics for Excel will search for the file from each drive you have access to. If we can't find the file from any of the drives, you will see the following message:
Please make sure the file is stored to one of the displayed drives. Click on the 'Open drive' links to verify that the file is located in the intended drive.
In case you do not see a drive you have access to, the reason might be one of the following:
1. Access to the drive has been granted with a group access. We do not currently ask for the necessary permissions to search for these kind of drives.
2. The Sharepoint drive is nested to Site within another Sites. These kind of drives are not supported.
In case you need to schedule refresh to a file on drive that is not shown, recommended action to take would be to share the file with your own drive which Supermetrics for Excel has access to. Updates to shared files are normally saved to the original file as well.
Please contact support to revoke any previous authorisations.