I have several worksheets in a file. The first worksheet is what i call
"H"... i enter pertinent info that will be used in other worksheets... things
like Company Name, Case #, etc... In the other workbooks, i just set up the
reference to the "H" worksheet, and the specific cell i need. In some of my
of worksheets, and only in a particular cell, when I create the "formula" to
reference a cell in the "H" worksheet, it displays the formula, rather than
the result. For example, in "XYZ" worksheet, cell B6, i've entered =H!B45.
Result should be what's in cell b45 on the H worksheet.. but instead it
displays =H!B45. I've tried doing it in other cells on XYZ worksheet, and it
works like it should... i've even tried copying into that cell, but when I
change the cell it references, it keeps displaying the formula. I'm going
nuts here!