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.

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.

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


Replace @mailinator.com with @tiscali.co.uk


wrote in message
...
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.

On Mar 10, 11:34*am, cht13er wrote:
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 asharedworkbookthat 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 thesharedworkbookwill 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 thisworkbookfor years without incident. *Don't
know why this just started happening now.- Hide quoted text -

- Show quoted text -

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

On Mar 10, 11:46*am, "Sandy Mann" wrote:
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


Replace @mailinator.com with @tiscali.co.uk

wrote in message

...



Hi,

Thansk for your help.

My group here administers asharedworkbookthat 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 thesharedworkbookwill 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 thisworkbookfor years without incident. *Don't
know why this just started happening now.- Hide quoted text -

- Show quoted text -

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

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


Replace @mailinator.com with @tiscali.co.uk

On Mar 11, 10:58*am, "Sandy Mann" wrote:
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


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.

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


On Mar 12, 3:10 pm, wrote:
On Mar 11, 10:58 am, "Sandy Mann" wrote:



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


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.

On Mar 11, 10:58*pm, "Sandy Mann" wrote:
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 acorruptworkbook

--
Regards,

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


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