what do have for a function, and what are the values of the
cells it is dependent upon. Possibly you did not install
the Analysis Toolpak.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chester1" wrote in message ...
I ahve a spreadsheet, when I open it in Excel 2000 and click do not update
the sheet is fine. But when I do the same thing in Excell 2003 all the
figures are replaced with #Value. Is there a setting I need to change so
that the sheet will open in 2003 just as it does in 2000.
--
Regards Clair