 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008Shared Workbook - "1/0/1900" displays for some users
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, digitalmadri...@gmail.com wrote: > Hi, > [quoted text clipped - 15 lines] > 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? [quoted text clipped - 24 lines] > > - Show quoted text - No. We are all on the same Excel platform which si Excel 2003. Thanks though.. Does the user who entered the date have "Transition Formula Entry" checked in Tools > Options > Transition?  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Hi, > [quoted text clipped - 15 lines] > 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? [quoted text clipped - 34 lines] > > - 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 SignatureRegards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > >No the users in our group all have that item unchecked. Should we > >have it checked [quoted text clipped - 12 lines] > sandyma...@mailinator.com > 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, digitalmadri...@gmail.com wrote: > > >No the users in our group all have that item unchecked. Should we > > >have it checked [quoted text clipped - 22 lines] > anyone would have on this point and/or the first post would be > appreciated. > >No the users in our group all have that item unchecked. Should we > >have it checked [quoted text clipped - 12 lines] > sandyma...@mailinator.com > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.