HI

We have recently moved from XP/Off2003 to W7/Off2010, we had many calculation tools that used an addin to connect to out databases and retrieve data.

There is a reference to the add in in the VBA refernces. These no longer work, the way round this is to have the addins all checked in the Excel UI, this is working as a fix, but the addins take around 30seconds to load, which is too long.

If i open the workbook, i get a cant find object or library on the reference to the addin, i.e. addin.proc1

When i close it and reopen it, its ok..

Any ideas?


TIA

Nathan.