#REF

[barwarner]

I have Excel as part of Office 2002. I recieved a speadsheet from a coworker today and in many of the cells the cell formula is not working - all I see is #REF in the cell. What would this indicate? Thanks.

Barry

 

[BobSchleicher]

A formula is referencing something that it can't access.

Such as your co-worker might have made a formula referencing a document on his desktop, then when he emails it to you and you open it the formula is looking for the exact location (his desktop) and it doesn't exist so it gives you a reference error - #REF.

BobSchleicher

 

[KenWright]

When you opened the file did you get prompted to update links? If you chose yes then that is likely why, as per Bobs note the file tries to link to the documents it is tied to, cannot find them and dies on you. If you hit no, then it keeps the original values from when it was saved and does not try looking for the file.

Regards
Ken.................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------