Excel 4.0 Macro with Shared Workbook Issue

[EngineerN]

I have an excel macro workbook (File A) that uses the "Name Manager" tool to list the tab names in the file on a worksheet called "SUMMARY" (via a simple macro: LINK)

I have another excel file (File B) that adds File A ("SUMMARY") as a linked workbook. When I connect this worksheet from File A, all of the cells which use the macro formula show an error as if it is unable to recognize the macro. How can I get File B to recognize the macro in File A so the list of tab names in File A show up in File B?

Thanks in advance!

 

[GlennUK]

How about if both workbooks are open at the same time - does it work then?