Need to open File A and File B at the same time, or File B could not calculate.Otherwise, you need to use Data Query for it