Function Problems

Fix Excel RTD Function Not Working After Office 365 Update

John WilsonJohn Wilson Nov 4, 2026 868 views

Question details

The user needs to restore the functionality of the Excel RTD (Real-Time Data) function, which stopped pulling data following a recent Office 365 update.

How to Fix the Excel RTD Function After an Office 365 Update
Product
Microsoft Excel
Device & OS
Windows
Scenario
Using the RTD function to retrieve live, real-time data into a spreadsheet after a recent software update.
Observed behavior
The RTD function completely stops working without any clear error messages, failing to update or retrieve real-time data.
Before you start

Ensure your computer is connected to a stable internet network, as the Online Repair process requires downloading fresh installation files from Microsoft's servers to replace missing or corrupted components.

Solution 1Recommended

Run an Online Repair for Microsoft Office 365

The most effective way to resolve broken Excel functions and COM add-ins after an update is to perform a comprehensive Online Repair of the Office installation.

Sometimes, an Office 365 update can corrupt specific registry keys or library files required by the RTD function. Running an Online Repair will identify and replace these corrupted files automatically.

1
Open Control Panel

Press the Windows key, type 'Control Panel' into the search bar, and press Enter to open it.

2
Access Programs and Features

Navigate to 'Programs' and select 'Programs and Features' to view your installed applications.

3
Select Microsoft Office

Scroll down the list of installed applications, locate 'Microsoft 365' or 'Microsoft Office', and click to select it.

4
Initiate the Change Wizard

Click the 'Change' button located at the top menu bar of the program list.

5
Run Online Repair

In the prompt that appears, select 'Online Repair' (do not choose Quick Repair) and click 'Repair' to begin the process. Wait for the repair to complete and restart your computer before testing the RTD function again.

Run an Online Repair for Microsoft Office 365
Quick Repair Alternative: You can try running a 'Quick Repair' first if you have limited internet data, but 'Online Repair' is highly recommended for update-related registry corruption.
Free Microsoft Office alternative

Switch to WPS Office for Stable Spreadsheet Management

Tired of unexpected software updates breaking your spreadsheet workflows and data streams? WPS Office provides a stable, lightweight, and completely free alternative to Microsoft Office. Enjoy excellent compatibility with Microsoft formats and a user-friendly interface without the hassle of forced background updates disrupting your work.

  1. 1. Download the Installer: Visit the official WPS Office website and download the free installer for your operating system.
  2. 2. Install WPS Office: Run the downloaded installation file and follow the straightforward on-screen prompts to set up the software.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files to resume your data analysis immediately.
Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) file formats.Lightweight installation ensures fast startup and smooth, stable operation for advanced calculations.Reliable environment that is not subject to unexpected background feature updates.Familiar tabbed interface makes migrating from Office 365 practically seamless.
microsoft office alternative - wps office

Frequently Asked Questions

What does the RTD function do in Excel?

The RTD (Real-Time Data) function is used to retrieve data from a program that supports COM automation in real-time. It is commonly used in financial modeling to stream live stock prices, trading data, or live telemetry directly into a spreadsheet cell.

Why do Excel updates sometimes break functions like RTD?

Software updates can occasionally overwrite or fail to properly register the dynamic link libraries (DLLs) or COM add-ins required by advanced data functions. This leads to the functions failing to execute despite the external data source being active.

Will an Online Repair delete my Excel files?

No, performing an Online Repair on Microsoft Office only resets and replaces the application's core program files. All of your personal spreadsheets, documents, custom macros, and saved data will remain completely untouched.

Can I roll back an Office 365 update to fix the issue?

Yes, if an Online Repair does not work, you can revert to a previous version of Office using the Office Deployment Tool or specific command-line scripts to install an older build where the RTD function was working correctly.