Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 | Excel Programming | |||
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 | Excel Programming | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Programming | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) |