How to Use Copilot in Excel With Real-Time Data RTD Functions

You want to analyze live streaming data in Excel using Copilot but your RTD Real-Time Data functions show empty cells or errors. Copilot requires structured data to generate insights, and RTD functions that pull from external sources like Bloomberg or internal servers often break this structure. This article explains how RTD functions interact with Copilot, what prerequisites you need, and the exact steps to make Copilot read and analyze your real-time data.

How RTD Functions Work With Copilot in Excel

RTD Real-Time Data functions use the =RTD() formula to pull live data from a COM automation server. This server can be a third-party add-in like Bloomberg, Reuters, or a custom internal server. The RTD function refreshes automatically at intervals set by the server, typically every few seconds.

Copilot in Excel operates on structured data. It cannot read raw RTD formulas or disconnected cells. To analyze live data with Copilot, the RTD output must reside inside an Excel table with clear column headers. Copilot then treats the table as a data source and can answer questions like “What is the average price for the last 10 ticks?” or “Show me the highest volume.”

Prerequisites for Using Copilot With RTD Data

Before you start, confirm these conditions are met:

• You have a Microsoft 365 subscription that includes Copilot for Microsoft 365. Copilot Pro does not support RTD data analysis.
• The RTD server is running and connected. Check that the =RTD() formula returns values in at least one cell.
• Your Excel version is Version 2402 or later Build 16.0.17328.20000 or later. Go to File > Account > About Excel to check.
• The workbook is saved to OneDrive or SharePoint. Copilot cannot analyze data in locally saved files.

Steps to Prepare RTD Data for Copilot Analysis

Follow these steps to convert your RTD output into a Copilot-friendly table.

1. Enter the RTD formulas in a clean range
   In a new worksheet, place your RTD formulas in a contiguous block of cells. For example, put stock symbols in column A, current price in column B, volume in column C, and change percent in column D. Ensure every column has a header row with descriptive text like “Symbol”, “Price”, “Volume”, “Change %”.
2. Convert the range to an Excel table
   Select the range including the header row. Press Ctrl+T on Windows or Cmd+T on Mac. In the Create Table dialog, confirm the range and check “My table has headers”. Click OK. The range now has filter arrows and a blue border.
3. Name the table
   Click any cell inside the table. On the Table Design tab, in the Properties group, replace the default name like Table1 with a meaningful name such as RTD_LiveData. Press Enter. This name helps Copilot identify the data source in queries.
4. Save the workbook to OneDrive or SharePoint
   Click File > Save As. Choose OneDrive – YourCompany or a SharePoint document library. Enter a file name and click Save. Copilot requires cloud-stored files to read data.
5. Open the Copilot pane
   On the Home tab, click the Copilot button in the right side of the ribbon. The Copilot pane opens on the right side of the Excel window.
6. Ask a question about the live data
   In the Copilot text box, type a natural language query. For example, type “Show me the top 5 values in the Volume column” or “What is the average Price?” Copilot analyzes the table and returns the result in the pane. It may also add a chart or summary to the worksheet.

If Copilot Returns No Data or Errors for RTD Cells

If Copilot responds with “I couldn’t find data to analyze” or returns empty results, check the following issues.

Copilot says “No structured data found”

This error appears when the RTD output is not inside an Excel table. Select the entire range of RTD values and the header row. Press Ctrl+T and confirm the table creation. Then ask Copilot again.

Copilot returns stale values

Copilot reads the current cell values at the moment you ask a question. If the RTD server refreshes every 5 seconds but you see old numbers, force a recalculation. Press F9 to recalculate all formulas in the workbook. The RTD values update immediately. Then ask Copilot again.

Copilot cannot find the table by name

If you named the table but Copilot still ignores it, verify the table name. Go to Formulas > Name Manager. Look for a name that matches your table. If the name is missing, re-select the table and assign the name again on the Table Design tab. Also confirm the workbook is saved to OneDrive or SharePoint.

RTD server does not start when workbook opens

Some RTD servers require manual activation. Open the COM add-in from the Developer tab or from the Add-ins dialog. Once the server shows “Connected” or “Running”, the RTD cells populate. Then save the workbook again. Copilot can now read the data.

Copilot with RTD Data vs Copilot with Static Data: Key Differences

Item	RTD Real-Time Data	Static Data
Data source	External COM server Bloomberg, Reuters, custom	Typed values or imported from CSV, database
Refresh behavior	Automatic at server-defined interval	Manual refresh or no refresh
Copilot query timing	Reads values at the moment of the question	Reads values at the moment of the question
Table requirement	Mandatory for Copilot to recognize data	Recommended but not strictly required
Common Copilot tasks	Show latest value, filter by threshold, rank by column	Summarize, chart, find trends, create formulas

Conclusion

You can now use Copilot to analyze live data from RTD functions by converting the output into an Excel table and saving the workbook to the cloud. Always name the table and keep the RTD server active before asking questions. For advanced analysis, try asking Copilot to “Highlight rows where Price exceeds 100” or “Create a line chart for the last 20 Price values.” This approach works with any RTD server that returns numeric or text values in cells.