Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dates are saved with a future date
I work in an office with about 8 computers networked. We have noticed
recently that a few excel spreadsheets have been saved with a future date, ie 12/17/05. We checked that all computers have the current date & time. When this happens it erases the new information. Please help!!! Thanks We are using Excel 2002 & 2003 |
#2
|
|||
|
|||
The date and times may be correct but are they in the correct time zone?
Goto <Start<Control panel<Date and time<Time zone Regards. Bill Ridgeway Computer Solutions "Eates-a-Lot" wrote in message ... I work in an office with about 8 computers networked. We have noticed recently that a few excel spreadsheets have been saved with a future date, ie 12/17/05. We checked that all computers have the current date & time. When this happens it erases the new information. Please help!!! Thanks We are using Excel 2002 & 2003 |
#3
|
|||
|
|||
I checked that, and there was only one that was different. But the dates are
changed like months in advance. For example, one was saved 2 days ago, but the date modified is December 20, 2005. Which is impossible. The reason we found this error is because we sync the files to laptops, so employees can do work at their home or at a client site. Anymore ideas? "Bill Ridgeway" wrote: The date and times may be correct but are they in the correct time zone? Goto <Start<Control panel<Date and time<Time zone Regards. Bill Ridgeway Computer Solutions "Eates-a-Lot" wrote in message ... I work in an office with about 8 computers networked. We have noticed recently that a few excel spreadsheets have been saved with a future date, ie 12/17/05. We checked that all computers have the current date & time. When this happens it erases the new information. Please help!!! Thanks We are using Excel 2002 & 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
future dates | Excel Worksheet Functions | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel |