Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Can't get Excel 2010 to activate an RTD COM Add-in

25 Oct 2013   #1
rcdunbar

Windows 7 Pro 32-bit
 
 
Can't get Excel 2010 to activate an RTD COM Add-in

I have installed Sterling Trader Pro (a stock trading application, for which I have a Sterling account) with the Excel RTD (Real Time Data) option. I plan to update my Sterling-oriented Excel trading application to use RTD instead of DDE to access Sterling's real time market feed. The installation was uneventful and reported as successful, including the RTD add-in, and the add-in's dlls show up where I expect them to be.

Excel 2010 lists the add-in in Options > Add-ins as an inactive COM add-in. However, the Location is identified only as mscoree.dll, which is a system file in Windows\System32. Unlike all other listed add-ins, active and inactive, there is no path given. When I select this add-in in Manage COM Add-ins, Load Behavior states "Not loaded: A runtime error occurred during the loading of the COM Add-in". And of course the add-in doesn't show up in Excel's Add-ins ribbon.

Sterling tech support confirms that I have all the Excel Add-in and Trust Center options set correctly; and .Net Framework 4, Client & Extended, is installed and up-to-date, as is Win 7 Pro. I tried using RegSvr32 (cmd prompt, as admin) to register the add-in's 5 dlls; but in each case it said the dll was loaded, but "entry point DllRegisterServer was not found". So far nothing that I or tech support has tried has helped. Otherwise my PC, on which I recently did a clean reinstall of Win 7 Pro, works like a champ.

Can anyone suggest how to get this add-in to activate and work? I'm going to write an RTD tutorial for SevenForums once I get it to work.


My System SpecsSystem Spec
.

26 Oct 2013   #2
Golden

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64
 
 

Hi,

Try turning UAC OFF before installing the Add-On.

COM Add-Ins for Excel Student Edition

Regards,
Golden
My System SpecsSystem Spec
26 Oct 2013   #3
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

Quote   Quote: Originally Posted by rcdunbar View Post
I have installed Sterling Trader Pro (a stock trading application, for which I have a Sterling account) with the Excel RTD (Real Time Data) option. I plan to update my Sterling-oriented Excel trading application to use RTD instead of DDE to access Sterling's real time market feed. The installation was uneventful and reported as successful, including the RTD add-in, and the add-in's dlls show up where I expect them to be.

Excel 2010 lists the add-in in Options > Add-ins as an inactive COM add-in. However, the Location is identified only as mscoree.dll, which is a system file in Windows\System32. Unlike all other listed add-ins, active and inactive, there is no path given. When I select this add-in in Manage COM Add-ins, Load Behavior states "Not loaded: A runtime error occurred during the loading of the COM Add-in". And of course the add-in doesn't show up in Excel's Add-ins ribbon.

Sterling tech support confirms that I have all the Excel Add-in and Trust Center options set correctly; and .Net Framework 4, Client & Extended, is installed and up-to-date, as is Win 7 Pro. I tried using RegSvr32 (cmd prompt, as admin) to register the add-in's 5 dlls; but in each case it said the dll was loaded, but "entry point DllRegisterServer was not found". So far nothing that I or tech support has tried has helped. Otherwise my PC, on which I recently did a clean reinstall of Win 7 Pro, works like a champ.

Can anyone suggest how to get this add-in to activate and work? I'm going to write an RTD tutorial for SevenForums once I get it to work.
Hi there
I use some professional Market trading add ins too -- I found that most don't work with the 64 bit version of Office / Excel -- try and see if they work in the 32 bit version of office even on 64 bit version of Windows..

For example I trade options (on the US markets) - I get real time option prices plus a load of other data also in real time downloaded from the CBOE via an EXCEL addin - this doesn't work with the 64 bit version of EXCEL - worked fine with the 32 bit version.

Other than that I would just suggest contacting the supplier.

Meanwhile if you NEED this for trading I'd suggest you run your previous OS as a Virtual machine so you can keep using the trading software until the problem is fixed.

Cheers
jimbo
My System SpecsSystem Spec
.


26 Oct 2013   #4
rcdunbar

Windows 7 Pro 32-bit
 
 

Thanks Golden & Jimbo45

I have long had UAC turned all the way down, which I assume is the same as turning it off. Sterling requires it to be off, and I have always found it to be a pain in the back side.

My Windows 7 Pro is definitely 32-bit.

Why would the Sterling RTD Add-in in the Excel Add-ins page appear as mscoree.dll? Intuitively I would expect it to show as C:\Sti\RTD\StiRTD.dll, which is the installed dll I would expect to use in a RTD worksheet formula as the RTD server. Sti = Sterling Traders Inc. Could there be a registry setting somewhere that needs to point to that dll?
My System SpecsSystem Spec
30 Oct 2013   #5
Golden

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64
 
 

Quote   Quote: Originally Posted by rcdunbar View Post
I have long had UAC turned all the way down, which I assume is the same as turning it off.
Yes it is. I must say Im at a loss as to the issue. I'll try do some more research.
My System SpecsSystem Spec
31 Oct 2013   #6
rcdunbar

Windows 7 Pro 32-bit
 
 

Thanks, Golden

I have good news, sort of.
Last night I installed Trader Pro (with RTD) on my laptop, and the Excel RTD add-in works! The COM add-in appears (as mscoree.dll) in the active list, and RTD shows up in Excel's Add-ins ribbon. Unfortunately nothing has changed on the desktop PC. The laptop runs Win 7 Ultimate and Excel 2007, whereas the desk machine runs Win 7 Pro and Excel 2010. I don't see that either of these differences should be an issue, but, who knows.

I will try to compare various settings to try to spot the problem. Maybe, for instance, there's a service on the desk PC that isn't running, or a permission that isn't set right. Can you suggest areas to look at, or perhaps some logs to compare?

I did run sfc /scannow (admin cmd) again, and it reported no integrity violations. I've seen it written that one should run sfc two or three times, because it may be quietly fixing things each time. Do you have insight about that?
My System SpecsSystem Spec
Reply

 Can't get Excel 2010 to activate an RTD COM Add-in




Thread Tools





Similar help and support threads
Thread Forum
Bug in Excel 2010?
For my workbook, I have defined the default font to be 11 pt Calibri. However, when I select a row (or column) and select Clear Formats, the cells are reformatted to 10 pt Arial. To me, this seems like a bug. Am I missing something?
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Excel 2010
Hello, I'm having this weird problem with MS Office 2010. When I'm working on excel files tend to crash for no reason and too frequently when I try to open them. I have gotten these two messages: 1) Excel cannot complete this task with available resources. Choose less data or close other...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Excel 2010
Hi all I'm trying to add a little Calculator function to a Spreadsheet I use for trading shares. I pull basic data from YAHOO finance and would like to have at the bottom of a spreadsheet a calculator which would allow me to enter Nr of shares bought, Price Paid and return things like Profit /...
Microsoft Office
How to Activate Outlook 2010
Just finished reinstall of OS .... I need to activate my Outlook which I purchased by itself directly from MS. I have the key but I don't know how to enter it....
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 02:05.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App