Shared Workbook - "1/0/1900" displays for some users
Is that one user using Excel 2007, and the rest of you something
older?
C
On Mar 10, 11:18*am, wrote:
Hi,
Thansk for your help.
My group here administers a shared workbook that calculates a whole
bunch of things for a portfolio of assets. The core of the infromation
is a log of all activity in the protfolio (Buys, Sales, Repayments,
etc.) *We log this information by date.
We are having a problem here in that one person will enter a date for
some piece of activity as, say, 3/10/2008, and saves, but all the
other users on the shared workbook will see "1/0/1900" in that cell
where 3/10/2008 was entered. *I can't figure out why this is
happening. *I made sure they weren't entering it with a "=" sign and I
set formatting to "3/10/08" without the asterisk. *Nothing seems to
work.
We've also been using this workbook for years without incident. *Don't
know why this just started happening now.
|