Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Problem with Excel add-in and .NET

I have developed an Excel add-in for a customer. The add-in enables
users to retrieve data from a database by using WorkSheet functions
defined in the xla file. The xla file has references to a .NET
component (.dll). To be be able to use the component from Excel I have
used regasm.exe to create a type library (tlb file)

The User writes in a cell
=Quote('31/12/2009';'MSFT')
and Microsofts stock quote shows up.

These functions are heavily used in a excel workbook.
Since the spreadsheet is big and there's a lot of data to retrieve, it
takes about 20 seconds to open the spreadsheet for users with the
components installed. Let's call these users Group 1

Users without the add-in and the .NET component (Group 2) opens the
workbook in 2 seconds and can see the values, since the data is not
refreshed. In the cells, the users without the component see this type
of formula:

='C:\Program Files\QuoteManager\qm.xla'!Quote('31/12/2009';'MSFT')

So far so good. Now I have another category of users. They used to
have the component installed, but now they just need to see the
values. They want to move into group 2!

So I unregister the .NET dll, delete the dll, the tlb and the xla.

I open the workbook, but it does not open up in 2 seconds nor 20, it
takes several minutes, and excel is using as much processor as it can.
I suspect Excel is trying to refresh all cells, even though it should
not try.

I have searched the registry and i can see traces of the component in
several places including HKEY_CLASSES_ROOT. I tried to manually delete
the instances I found, but the workbook is still extremely slow.

I have tried everything but reinstalling the computer. How can I get
rid of the traces of my component that makes excel try to evaluate the
formulas?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Colon at the end of excel file name(ex: problem.xls:1, problem.xls financeguy New Users to Excel 2 January 15th 10 01:15 AM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 shashank kulkarni Excel Programming 0 October 5th 07 10:26 AM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 shashank kulkarni Excel Programming 0 October 5th 07 10:24 AM
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file BrianL_SF Excel Programming 6 October 7th 06 08:54 AM
Started out as an Access problem. Now an Excel problem RobertM Excel Discussion (Misc queries) 2 April 26th 06 07:30 PM


All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"