How to Automatically Reconnect Excel Data Streamer After a COM Port Disconnects
Question details
The user needs to know whether Excel Data Streamer can automatically restore a lost COM port connection and what manual or scripted methods can reconnect a disconnected device.

- Product
- Microsoft Excel Data Streamer
- Device & OS
- not provided
- Scenario
- During live data collection, a serial device or microcontroller disconnects from its COM port; the user wants the Excel Data Streamer feed to resume automatically without manually reopening settings.
- Observed behavior
- Excel Data Streamer does not include a built-in automatic reconnection toggle, so after a COM port drop the feed stays disconnected until manually or programmatically reconnected.
Before attempting any automation, confirm the USB cable, COM port assignment, device driver, and Windows USB power management settings are stable. Also close and reopen the Data Streamer tab once to verify that the device can reconnect manually.
Check the COM port, USB power settings, and device driver
Use this first to rule out unstable hardware or driver settings before adding automation.
Many disconnect problems are caused by Windows suspending a USB port or by a COM port number changing after a device reset. Stabilize these settings before trying scripts.
Press Windows+X and click Device Manager, then expand Ports (COM & LPT).
Right-click the device, choose Properties, open the Power Management tab, and clear 'Allow the computer to turn off this device to save power.'
In the Excel Data Streamer tab, open the connection settings and select the same COM port that Device Manager shows for the device.
Use a VBA Application.OnTime macro to detect and reconnect the COM port
Use this when the workbook must stay open unattended and you can run VBA code inside Excel.
Run an external serial monitoring script to re-establish the connection
Use this when a separate script or utility can monitor the COM port while Excel remains open.
Switch to WPS Office for a Free, Lightweight Alternative When Excel Data Streamer Automation Is Unavailable
Because Excel Data Streamer is a Microsoft Excel add-in, WPS Office does not alter its COM port behavior. WPS Office is a free, lightweight alternative that opens and saves Excel-compatible workbooks in a familiar ribbon interface, so you can continue general spreadsheet work without the same add-in complexity.
- 1. Download WPS Office: Go to the official WPS Office website and download the free installer for Windows, macOS, Linux, or mobile.
- 2. Open an Excel-compatible workbook: Launch WPS Spreadsheets and use File > Open to open an existing .xlsx or other Microsoft Office-compatible workbook.
- 3. Continue data work in the familiar ribbon UI: Use WPS Office spreadsheet tools for editing, charts, formulas, and data import without relying on the Excel Data Streamer COM port add-in.

Frequently Asked Questions
Does Excel Data Streamer include an automatic reconnect option?
No, the Data Streamer tab does not generally provide a built-in auto-reconnect toggle. You need VBA, Office Scripts, or an external monitoring utility to detect the lost connection and reconnect.
Why does my Excel Data Streamer COM port keep disconnecting?
Common causes include USB power saving, a faulty cable, a driver update that changes the COM port number, or the device resetting. Check Device Manager power options and Windows USB selective suspend first.
Can VBA automatically reconnect Excel Data Streamer?
Yes. In the VBA editor, opened with Alt+F11, insert a module and create an Application.OnTime routine that checks the serial port and reconnects when the device returns.
What should I check before setting up a reconnect script?
Confirm the cable, COM port assignment, device driver, and power management settings. Reopen the Excel Data Streamer tab and verify that manual reconnection works before relying on automation.
Does WPS Office support Excel Data Streamer COM port connections?
WPS Office does not implement the Excel Data Streamer add-in, but it can open and edit Excel-compatible workbooks for general spreadsheet tasks.





