Script for Auto-Update of Excel Chart in SharePoint 

I have an excel sheet with data connected to a database. I have saved it on the SharePoint. I am using the script you shared to update the file. It's not working. Can you please help.

I love the script idea. My challenge (I think) is due to our company policy I can't get Excel out of read only mode. So I can see that the spreadsheet is pulling up, because I made it visible in the script, and it looks like it's doing the refresh all and I see the saving message but I noticed the spreadsheet never gets out of that read only mode. It only updates when I manually open and then click the button to edit. I've tried all kinds of tricks such as trying to change settings for SharePoint collaboration on the file, taking off read only on the file and library folder itself (which then seems to get set back to read only or won't allow me!) changing trust permissions on the file itself (Excel 2016 btw) with those settings under File -> Options -> Trust Center (both Protected View and Trusted Locations) and it seems like I get foiled every time! :-) So it feels like in short I'm hemmed in by our Corporate policies. :-) I did see the Pivot Explorer solution. Did you develop that? Anyway, hoping we can get that but in the mean time! ….

I get an error from using your updated script that comes up when I run the script, and it says "Unknown runtime error: 'xl.DisplayAlerts' and the error code is 800AC472" I cannot seem to find a meaning or cause to this error but it could possibly be due to it opening the excel file in read-only mode by default? Anyone else have a solution? Thanks

at least to skip the update promt, 1. On the Data tab, in the Connections group, click Edit Links 2. Click Startup Prompt. 3. Select the option that you want. support.office.com/en-us/article/control-when-external-references-links-are-updated-21e995b5-bab1-4328-8ab3-dd357fe0e653 now its only the "cant connect to server"

I am trying to get an Excel file that lives in SharePoint online to do this. It works fine until I configure the Task Manager settings to run when not logged in. I'd like this process to run even when I'm on vacation and wouldn't be logged in. Ideas?

Hi! Thanks for the Script. I have SharePoint Online and I have tried the same method but it's not updating the document in the SharePoint document library. I can see the task running in the task history and even i can see Excel opening, running and closing in the background processes in task manager. But it does not update the Excel file in the document library. I have tried a local folder to update the same Excel file and it worked perfectly. Any tips to get this working in SharePoint Online?

I don't see where to obtain the "password"

Talk about jumping through hoops! I wish Microsoft would make this easier since it kind of negates the idea of collaboration via SharePoint. Any idea if this works with Excel 2010 desktop client (license key:ed) in combination with 365? I have an old copy that wouldn't need the monthly log-on.

I get the "Do you wish to overwrite file?"-dialogue every minute, lol! Any workaround?

Hi! I get the "How do you want to open this file?" -dialogue (every minute). Could you please support?

Any chance that the script could be embedded in the page? The task scheduler is tied to the computer in which it is scheduled. If I could get the script to be ran on the page every time it was open then it would run the script.

Hi, The file is opening by default in protected mode, so there is no update. Any idea how to work around this? Thanks

Hi, thank you for sharing this. Any idea why my file is not saving in my sharepoint location?