Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Advanced Settings for the Data Streamer add-in will apply to all workbooks that are using Data Streamer. 

Console Tab

Excel Data Streamer add-in Advanced settings Console tab

The console will display raw serial data when connected to a device. This is useful for troubleshooting connection issues with your device.

Console options:

  • Check Show receive data to see received data, and Show transmit data to see transmitted data.

  • Clicking Clear will clear the contents of the console.

  • Data Rows - select how many rows you want to display.

Settings Tab

Excel Data Streamer add-in Advanced settings Settings tab

User Interface options:

Contains settings related to the user interface, like adjusting when dialogs appear and streamlining the connection process.

  • Always show Device Connected dialog – Sets whether or not you would like to see the Device Connected confirmation dialog, which includes guidance on how to start seeing your data. The default is checked.

  • Always show Recording Saved dialog – Sets whether or not you would like to see the Recording Saved confirmation, which includes receiving guidance how to replay that data. The default is checked.

  • Automatically stream data on device connect or file import – Do you want to visualize your data faster? Checking this will automatically Start Data from your device, or Play Data from your file after selecting it. The default is unchecked.

COM Port options:

Contains settings related more generally to serial connections. These settings may be necessary if you’re connecting a device which is not compatible with the default settings. Connect a serial device to enable these settings.

You can also adjust the Baud as required by your device. The default is 9600.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

What is the Data Streamer add-in?

Enable the Data Streamer add-in

How to stream data with the Data Streamer add-in

Workbook settings for Excel's Data Streamer add-in

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!