Try Tools Options View tab under the Windows Options uncheck the Formulas
box

Elisabeth

"Roger Thompson" wrote:

Hi,

I am using a worksheet that loads data referenced to another separate
worksheet, ie contents of cell equals data inputted to location in other
worksheet. I am now finding that instead of the data appearing in the cell
(e.g. 1234) I am getting the location of the data appearing (e.g. =data!A100
) I am sure that this is just a problem with cell formatting but can someone
point me in the right direction please?

Thanks