=today() returns date of 00/01/1900

[KezD]

Hi everyone

I'm using Excel 2003.

I have a spreadsheet which contains an =today() function. When I view the spreadsheet it correctly displays today's date and updates each day as you'd expect. When my colleague opens the same spreadsheet on her machine, the today's date function is not updating. If using her machine I type =today() in a separate cell of that same spreadsheet just to see what it will do, it returns the date 00/01/1900!

If I create a brand new workbook on her machine and then type =today() in cell A1, it returns 00/01/1900!!

The date and time properties on her computer are correct. In Excel the Tools->Options->Calculation is set to Automatic. Pressing F9 doesn't resolve this issue.

Help please!!
Thanks.

 

[cyrilbrd]

Re: =today() returns date of 00/01/1900...CMOS

those are PC right?
what does the clock on your colleague's machine indicates?
sounds like a CMOS setup related problem, but i might be wrong.
CMOS require a small battery such as a CR2032.

If you can check on another machine then it means the problem is localized on one machine.

 

[cyrilbrd]

Hi everyone

I'm using Excel 2003.

I have a spreadsheet which contains an =today() function. When I view the spreadsheet it correctly displays today's date and updates each day as you'd expect. When my colleague opens the same spreadsheet on her machine, the today's date function is not updating. If using her machine I type =today() in a separate cell of that same spreadsheet just to see what it will do, it returns the date 00/01/1900!

If I create a brand new workbook on her machine and then type =today() in cell A1, it returns 00/01/1900!!

The date and time properties on her computer are correct. In Excel the Tools->Options->Calculation is set to Automatic. Pressing F9 doesn't resolve this issue.

Help please!!
Thanks.

KezD, if my theory is correct, go to this link...

http://www.computerhope.com/issues/ch000239.htm

 

[Michael M]

Hmmm, you could also try

Tools > Options > Transition
untick the boxes for "transition formula evaluation" and "transition formula entry".
Re-enter the date

 

[Michael M]

deleted...duplicate post

 

[KezD]

Hi cyrilbrd - these are PCs, yes. I don't think it's the CMOS but thanks for the suggestion. Much appreciated!

 

[KezD]

Hmmm, you could also try

Tools > Options > Transition
untick the boxes for "transition formula evaluation" and "transition formula entry".
Re-enter the date

Hi Michael M - thanks for your suggestion. Those two checkboxes in Tools -> Options -> Transition are already unchecked though, so I guess it's not that!

 

[Andrew Poulsom]

When you enter =today() does it change to upper case? If not check that there isn't an Add-In installed that contains a function with that name.

 

[Michael M]

If this is a one off occurrence ??
Maybe the old reboot, restart excel method may be the option

 

[KezD]

When you enter =today() does it change to upper case? If not check that there isn't an Add-In installed that contains a function with that name.

Hi Andrew - yes, entering =today() does then change to uppercase when viewed in the formula bar. Great suggestion about Add-Ins however there's nothing checked in that list, so I don't think it's that.