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

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

Hi Clair,
a missing Add-In seems like most likely since you said it was
working before, but you should also look at #VALUE! in help.
---
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.

"Chester1" wrote ...
I have 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