[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


runtime error 1004

Posted on 2007-07-28
Medium Priority
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

ID: 19588246
@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

ID: 19589010
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.

Accepted Solution

npinfotech earned 2000 total points
ID: 19598671
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.  
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.


Author Comment

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

Expert Comment

ID: 19603096
Glad it worked out.  Thanks for the great grade!

Expert Comment

ID: 20303697
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

ID: 39216288
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: I have always been a big fan of Windows but my liking towards it is slowly being eroded by the variety of other Applications that I encounter, when I browse the Web. Most of the software available is free and maybe Open Source too. …
Have you ever had a hard drive that you can't boot into, but need to change the registry? Here is the solution! This article guides you through accessing and editing a registry of a non-primary drive. To read registry information on a non-prim…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
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…

834 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