Excel Data Refresh

Senior Member

I have a shared Excel file stored on our Sharepoint site. I run a powershell script each morning that opens and refreshes a power query to update inventory. 

If a user opens the Excel workbook locally (in app) they are prompted with a Privacy Settings Message. This in turn breaks/stops my automated script from opening and refreshing the queries each day as I get prompted to update the Privacy Settings on my end. 


This is my issue...https://answers.microsoft.com/en-us/msoffice/forum/all/privacy-levels-not-saving-for-file-but-per-us... 


What are my options or workarounds here? Thank in advance.


0 Replies