You may be missing an add-in such as the Analysis ToolPak

Navigate: Tools,Addin

"Barry" wrote:

I am using Excell 2002 at the office. I have a problem viewing a spreadsheet
that a coworker sent me, which she prepared in Excell 2000. Some of the
cells display #REF, instead of the formula value.

Any ideas on how to resolve this would beappreciated. Thanks.

Barry