Clever Geek Handbook

Excel 2002 add-in does not load when you open an application

Good day,

I created an Excel.xla addin for Excel 2002. This strange behavior that I see only happens on my machine, but not on my colleagues. I would like to understand why.

The add-in has a UDF function that is called from many, many spreadsheets.

  • My add-in will be open when Excel opens. When I open a blank table, it works fine.

  • If I double click on the .XLS that links to the add-in, Excel does not load the VBA project and I get #NAME !. However, if I open Excel and then the spreadsheet, it works fine.

I checked the "disabled items" blacklist in the help menu. There's nothing there. This has been working for a long time; I can't figure out what has changed. I tried to include all registry entries with my add-in name and try again. Still not working.

Any ideas? Thank you. -Alan.

0


source to share


1 answer


Eventually I realized that all the problem tables contained RTD / DDE links in them, and it turns out that the data source process never works on my machine. Once I went to Edit-Links and removed those links everything worked fine.



0


source






More articles:


All Articles