How to Automate Excel Plug-In Login and Data Refresh
Question details
The user needs a method to automate the login authentication process and data refresh schedules for third-party Excel plug-ins, such as iLEVEL.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Setting up unattended data refreshes and automated authentication for third-party Excel add-ins using Power Automate or Office Scripts.
- Observed behavior
- Native Excel connections and Power Query refresh successfully with standard automation scripts, but third-party plug-ins fail to authenticate or refresh automatically without manual user intervention.
Ensure you have administrator permissions to create Power Automate flows and verify your company's security policies regarding desktop automation and unattended third-party API access.
Use Vendor-Supported Office Scripts and APIs
The most reliable and secure method is to check if the plug-in vendor supports unattended authentication or exposes a callable method for Office Scripts.
Many enterprise plug-ins offer command-line automation, dedicated APIs, or unattended scheduled refresh options specifically designed for enterprise environments.
Reach out to the third-party plug-in vendor (e.g., iLEVEL support) to confirm if their software supports unattended scheduled refreshes or API access.
If the vendor supports it or relies on native connections, open your Excel workbook on the web, navigate to the Automate tab, and create an Office Script containing the command: workbook.refreshAllDataConnections().
Create a scheduled cloud flow in Power Automate. Add the 'Run script' action for Excel Online, target your workbook, and select the script you just created to run at your desired intervals.

Utilize Power Automate Desktop for Interactive Sign-On
If the plug-in strictly requires manual button clicks or interactive Single Sign-On (SSO), use a desktop automation tool to simulate user actions.
Configure Native Data Source Settings
For plug-ins that integrate directly into Excel's native connection architecture, configure the built-in data source authentication settings.
Try WPS Office for Fast and Reliable Data Processing
While complex third-party plug-in automation relies heavily on specific Microsoft ecosystem tools like Power Automate, WPS Office provides a lightweight, highly compatible, and completely free alternative for your daily spreadsheet tasks, supporting advanced data analysis without the overhead.
- 1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install and launch: Follow the installation prompts and open the WPS Spreadsheet application.
- 3. Import and analyze: Open your existing .xlsx workbooks to instantly resume your data analysis tasks with full format retention.

Frequently Asked Questions
Why doesn't the workbook.refreshAllDataConnections() script refresh my third-party plug-in?
Third-party plug-ins often use proprietary authentication and data retrieval methods that operate outside of Excel's native data connection architecture. Because of this, standard Office Scripts or VBA commands cannot trigger them unless the vendor specifically provides a callable API.
Can I automate Excel plug-ins using standard Power Automate cloud flows?
Cloud flows can only interact with workbooks hosted on OneDrive or SharePoint by triggering native Office Scripts. If the plug-in requires a local desktop installation, interactive SSO login, or local network access, cloud flows alone cannot automate the process without bridging to a desktop flow.
What is the best way to handle Single Sign-On (SSO) prompts in automated Excel tasks?
If a plug-in vendor does not provide an unattended API token system for authentication, the most viable workaround is to use a Robotic Process Automation (RPA) tool like Power Automate Desktop. This allows you to visually simulate a user entering credentials, though it requires an active desktop session and compliance with IT security rules.




