Shared Workbook - "1/0/1900" displays for some users

[digitalmadrigal]

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.

 

[cht13er]

Is that one user using Excel 2007, and the rest of you something
older?

C

 

[Sandy Mann]

Does the user who entered the date have "Transition Formula Entry" checked
in Tools > Options > Transition?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[digitalmadrigal]

Is that one user using Excel 2007, and the rest of you something
older?

C







- Show quoted text -

No. We are all on the same Excel platform which si Excel 2003.
Thanks though..

 

[digitalmadrigal]

Does the user who entered the date have "Transition Formula Entry" checked
in Tools > Options > Transition?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk










- Show quoted text -

No the users in our group all have that item unchecked. Should we
have it checked?

 

[Sandy Mann]

No the users in our group all have that item unchecked. Should we
have it checked

An emphatic no!

Sorry I don't have any more guesses except a corrupt workbook

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[digitalmadrigal]

An emphatic no!

Sorry I don't have any more guesses except a corrupt workbook

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

Thanks for your help anyway.. I discovered today that the user
entering the dates was occassionally entering, say, 3/12/08 as
"3/12/8." Excel would recognize it and convert it into its proper
date format, but I'm wondering if this rather unorthodox way of
entering a date is causing a problem once the workbook is saved. In
any case, I've told my group to enter dates in full form as
"3/12/2008" and we'll see if that solves the problem. Any thoughts
anyone would have on this point and/or the first post would be
appreciated.

 

[cht13er]

If you have the ability to use an easy UserForm to save data (and it
would be easier/smarter for you to do so - it might not be), it could
help you weed out poor entries...

Chris

 

[Alan124]

An emphatic no!

Sorry I don't have any more guesses except acorruptworkbook

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

Hi,

It seems that the excel file is very important. I think you may try a
popular Excel file recovery tool called Advanced Excel Repair to
repair your Excel file. It is a powerful tool to repair corrupt or
damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Alan