Power Query Problems

How to Automate Excel Plug-In Login and Data Refresh

John WilsonJohn Wilson Nov 10, 2026 871 views

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.

How to Automate Excel Plug-In Login and Data Refresh
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.
Before you start

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.

Solution 1Recommended

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.

1
Contact the plug-in vendor

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.

2
Create an Office Script

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().

3
Schedule with Power Automate

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.

Use Vendor-Supported Office Scripts and APIs
Vendor Dependency: If the third-party plug-in does not expose a callable method to Excel, standard Office Scripts will only refresh native data connections and will bypass the plug-in entirely.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install and launch: Follow the installation prompts and open the WPS Spreadsheet application.
  3. 3. Import and analyze: Open your existing .xlsx workbooks to instantly resume your data analysis tasks with full format retention.
Fully compatible with Microsoft Excel formats (.xlsx, .csv, .xls).Lightweight architecture ensures large datasets open quickly and run smoothly.Built-in advanced data analysis, charting, and formatting tools.Completely free to use with a familiar, easy-to-navigate interface.
microsoft office alternative - wps office

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.