I am linking two files by having cells in one spreadsheet equal to
corresponding cells in another. However when I enter the equal sign in one
sheet, then go to the other sheet and click on the corresponding cell then
hit enter, the original cell displays the formula, not the value. I tried
copying cells above which display correctly, but that does the same thing.
Any ideas how to solve this problem?