In the attachment you'll find a zip file, containing BankA.xlsx and BankB.xlsm
Unpack them in the same directory.
Open each file in a separate instance of Excel.
Change something in the named range 'BankA" in the file 'Banka.xlsx';
Activate file 'bankB.xlsm' in the other Excel instance and check whether the changes have come through.
Bookmarks