Fix Excel RTD Function Not Working After Office 365 Update
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.

- 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.
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.
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.
Press the Windows key, type 'Control Panel' into the search bar, and press Enter to open it.
Navigate to 'Programs' and select 'Programs and Features' to view your installed applications.
Scroll down the list of installed applications, locate 'Microsoft 365' or 'Microsoft Office', and click to select it.
Click the 'Change' button located at the top menu bar of the program list.
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.

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. Download the Installer: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install WPS Office: Run the downloaded installation file and follow the straightforward on-screen prompts to set up the software.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files to resume your data analysis immediately.

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.




