Forum Discussion
How to automatically login and refresh a spreadsheet using a plug-in?
Hi. I have a requirement to automatically refresh a spreadsheet's data. I'm an Excel novice and have no idea how to do this automatically. To refresh the data in a manual fashion, I perform the foll...
How about Power Automate:
- Use Power Automate to open the workbook and run an Office Script that calls workbook.refreshAllDataConnections().
- This works well for Power Query or native Excel connections, but may not trigger third-party plug-in refreshes like iLEVEL unless they expose a callable method.