I migrated from Excel 2003 to 2007. In 2003, Workbook B contains VBA
programs. Workbook A references Workbook B. On opening WkBk A, it
automatically run macros in WkBk B.

On migrating to 2007, macros in WkBk B were not run automatically when WkBk
A was opened. On examining the Project panel, the referencing statement is
gone. I tried using Tools == Reference to add back the referencing and save
workbook. Exit everything. Open WkBk A again. Same problem, exactly as
described earlier. No referencing saved from previous run.

Have tried the following and all did not work:
1. saving Wkbk A and B as Excel 2007 workbooks
2. saving Wkbk A & B as Excel 2007 macro-enabled workbooks
3. start a new workbook C and simply referencing Wkbk A

Any fix?