Excel: Disabling Automatic Calculation from a remote workbook

Situation:
Workbook_A contains several macros that access an Oracle database.

I created a worksheet in Workbook_A that uses those macros. The worksheet has about 500 references to the Macros.

When I reopen Workbook_A, it opens fine and does not re-execute the macros.



The Problem:
I saved Workbook_A as an 'ADD-IN' (Workbook_A.xla).
I created a worksheet in a new Workbook_B (using Workbook_A as the add-in) using the same 500 references to the macos as described above.

When I reopen Workbook_B, it opens and immediately re-executes each of the 500 macros. Because of this recalculation, the open process takes several minutes.


Question:
Does anyone know how to set up the Workbook_B to not automatically re-execute the macros?

I have tried the following in thisworkbook object in both Workbook_A and Workbook_b without achieving the desired results.

Private Sub Workbook_Open()

'Turn off UpdateRemoteReferences to disable the entire recalculation of the workbook at open
ActiveWorkbook.UpdateRemoteReferences = False

End Sub



The reason I am pursuing this add-in approach is that these macros are used in 100 different spreadsheets and rather than maintain 100 spreadsheets I want to be able to maintain all of those macros in one place.