Links in 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chester1 - 02 Jun 2006 14:49 GMT

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.

Signature

Regards Clair

Reply to this Message

David McRitchie - 02 Jun 2006 22:06 GMT

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

> 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.

Reply to this Message

David McRitchie - 03 Jun 2006 11:26 GMT

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
[quoted text clipped - 4 lines]
> > 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.

Reply to this Message