For some wired reason, excel is remembering the last cell it was on from a page when I try to link a cell from another page. For example, I am balancing out a budget and I usually link #'s from one page(will say PAGE X) to another page(PAGE Y). I press = then I go to the other page, highlight the cell I want and then press return and DONE. Now when I do that, it is not linking over to page y. It actually puts the cell i wanted link onto page x on the last cell it was on before I tried to link. Hope this makes sense. If I type it in manually into page Y, it links and works. So confused, need HELP.
Solved by V. E. in 12 mins