I've set up several links between worksheets, however one is not working. It shows =Westgate!A16 in lieu of the data from the Westgate worksheet, which in this case should be 3-1. How do I get the correct information to show?
Make sure that the number format of this cell is not Text.
If it is currently set to Text, change it to General (or whichever format you prefer except for Text), then press F2 and Enter to force Excel to evaluate the formula.
Thanks Hans. That worked. Only issue is that I cannot highlight all of the cells and hit F2, must do them one at a time. Only 60 cells, but still inconvenient.
