Using the equal sign or plus sign does not link cells in separate worksheets anymore

[Roinda22]

I have two files, A and B. I used to be able to select a cell in File A, type = or +, and then click on a cell in File B, which would populate/link the cell in File A. Now nothing happens. Any suggestions would be greatly appreciated. Thanks!

 

[wigi]

Are the 2 files opened in the same Excel instance (program I mean)? So, open file A and then in the same Excel program, use the menu to open file B. Does it work then?

 

[Roinda22]

You are amazing! Thank you so much. That did the trick.

So simple but so frustrating...



Thanks again!

 

[wigi]

You are amazing! Thank you so much. That did the trick.

So simple but so frustrating...



Thanks again!

You're welcome