Linking across files is pretty much the same as linking across sheets and the main difference between .xlsx and ,xlsm is that .xlsm allows macros, while .xlsx does not
Try linking them the same way as you would across sheets and let me know how you make out?
Bookmarks