Word with embedded Excel object which has reference to addin
 

Dear all,

I encountered a great trouble in update an embedded Excel object having
a references to another addin.

Suppose there is a function called abc() written in the Addin and the
Excel file uses that function to perform calculation.

If I open the Excel file via the Excel application, it can reference to
the addin successfully.

Consider another case that the Excel file is linked in a Word document
via OLE. When I open the word document and update the Excel file. The
Excel file failed to link the addin UNLESS the addin file is
pre-opened.

May I ask whether anyone has idea on that? Thanks a lot.


Tom