Excel2000 on W2K an Win95

D

DaveWeller

Hi,

we share a .xls file between a computer with Windows 2000 and a computer
winth Windows 95. (We never access that file at the same time)

Can you tell me why each computer see the wrong date after the other one
entered it ? (The dates are totally messed up btw)


Thanks
 
J

J.E. McGimpsey

What does "totally messed up" mean?

If the dates are off by 4 years and 1 day, that indicates that one
of the two machines is starting up with a file in which the date
system is set to 1904 (Tools/Options/Calculation) and the other is
using the WinXL default 1900 date system. The date system used is
determined by the first workbook opened in the session.

If there's no systematic difference, I have no idea.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A couple questions BEFORE using Office 365 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Opening multiple Excel files from IE browser does not open in new instance of Excel - BUG? 0
Permissions set on Word files differ from other permissions 0
Problem with saving excel 2003 files on network 0
Can not open Access db with two PC at the same time? 2
Text Box in Access 2003 8
Create shared Web accessible Notebook in Onenote 2010 beta? 5

Top