Hi, I've created an excel file that is using power query to pull data from 12 separate tabs onto one master tab - all on the same document. I've set the Refresh to every 1 minute as the master sheet needs to be up to date at all times.
First issue that is coming up is the 'Refresh Paused - More than one person is editing, so 'Refresh data when opening' and 'Refresh every..' were paused.' error which is causing major issues as up to 12 people may be in the file at the same time editing the individual tabs so the master tab sheet needs to be up to date. The refresh works fine as long as only one person is in the document but as soon as 2 or more this error is showing.
Second issue is that for anyone who opens the file within SharePoint are unable to refresh the data themselves and receive an error stating 'Data Refresh Failed', meaning that even if the auto refresh isn't working that they can't even refresh the document manually.
Any help is appreciated!
First issue that is coming up is the 'Refresh Paused - More than one person is editing, so 'Refresh data when opening' and 'Refresh every..' were paused.' error which is causing major issues as up to 12 people may be in the file at the same time editing the individual tabs so the master tab sheet needs to be up to date. The refresh works fine as long as only one person is in the document but as soon as 2 or more this error is showing.
Second issue is that for anyone who opens the file within SharePoint are unable to refresh the data themselves and receive an error stating 'Data Refresh Failed', meaning that even if the auto refresh isn't working that they can't even refresh the document manually.
Any help is appreciated!
