ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #REF (https://www.excelbanter.com/excel-discussion-misc-queries/40916-ref.html)

Barry

#REF

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

Bean123r

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

All times are GMT +1. The time now is 05:17 AM.