runtime error 1004

Posted on 2007-07-28
Last Modified: 2013-06-03
Whenever I try open excel 2007 i get the following error message: Runtime error 1004 Unable to get the RTD property of the worksheet function class.  I have tried un-installing and re-installing Office 2007, and I have run SFC /SCNNOW as well as Norton to check for virus or spyware. No problems show up. I don't want to do a system recovery, because I have proprietary software that would be difficult to re-install. My operating system is windows xp pro
Question by:templetonl

    Expert Comment

    @RTD:Microsoft Excel 2002 provides a new worksheet function called RealTimeData (RTD). This function allows you to call a Component Object Model (COM) Automation server so that you can retrieve data in real time.

    When you start Excel, all the files that are located in the XLStart folder are automatically opened. This behavior occurs regardless of the type of file. Additionally, if you specified an alternative startup folder for Excel, every file in that folder is also automatically opened.

    Maybe there is in your XLStart folder an Excel file with an VB-script or macro that wants to setup this RealTimeData server (to give you perhaps all 10 seconds stock prices), but cannot  (connect to your internet provider, maybe).
    gives you more information especially the manual steps to prevent files from automatically opening in Excel.



    Author Comment

    Thanks for your suggestion.  I checked the XLStart folder and there were not any files other than a pdf maker file (which I removed).  I am still receiving the same error message as before.
    LVL 8

    Accepted Solution

    There might be an add-in that is looking for an RTD server.  If that's the case, you can go to "tools/add-ins" and uncheck whichever one is causing the problem.  

    Author Comment

    Thanks for your help.  I had a Bloomberg add-in that was causing the problem.  Great job!
    LVL 8

    Expert Comment

    Glad it worked out.  Thanks for the great grade!

    Expert Comment

    i seem to have the same problem as the person who posted the question. The addin that is causing the "runtime error 1004: Unable to get the RTD property of the WorksheetFunction Class", i'm pretty shore is bloomberg's excel tools addin. However, I really need to use excel with this addin so I don't want to solve the problem of unclicking the addin. Do you know why my excel does not like this addin. I've spoken to bloomberg and they think it's a windows problem not a bloomberg one as they say the addin is completely compatable with excel 2007?
    Any help would be great thanks

    Expert Comment

    Hello, i had the same problem and indeed the bloomber add-in is causing the problem, but the fact is that i want the bloomberg add-in to be running, how can i correct the problem in order to get the add-in running again?


    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    My purpose is to describe the basic concepts of virtual memory as implemented in a modern Windows-based operating system. I will also describe the problems inherent in older systems and how virtual memory solves them. The dark ages - before virtu…
    The way I use Experts Exchange to assist me in analyzing and diagnosing a problem is I first enter a Verbose Question at Experts Exchange like: Office 2007 will hang when opening and saving files I then launch WordPad (any text editor will do) an…
    Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
    In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now