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.
