I believe, and someone may correct me on this, that the key is here:
The prompting you're seeing is to fetch data from a CLOSED workbook, hence the prompt. When you have both workbooks open in memory, Excel will treat them as live links and update them automatically....Without closing A, open B.xlsx...
Bookmarks