ExcelRefresh
ExcelRefresh copied to clipboard
command line utility to refresh Excel documents and their external connections, query tables and pivot tables.
Hello, i have add the batchfile as Task on Windows 10 but wont work. When i start the bat manually this works. Someone have same Problem?
Would be great if you could include error codes from the excellent little app. I am using it in a batch file and trying to catch errors with %errorlevel% variable....
Changes in SharePoint mean that office files are by default opened read-only, therefore ExcelRefresh will fail to save. Adding a call to theWorkbook.LockServerFile(); did the trick for me.
I tried to run this on client's Windows Server and got error message: XLRefresh has stopped working. Clicking Debug opens Visual Studio code. Is this not supposed to run on...