Linked cell will not update from open event

[Liz_I3]

Hi
I have forumulas in workbook A that reference named ranges in workbook B. If both workbooks are open all works fine.

I thought I would open workbookB automatically when WorkbookA is opened. But when Workbook B is opened from the Workbook_Open() event the links will still not update. if I manually reopen WorkbookB they update.

Does anyone know how to fix this?

Thanks
L