Microsoft Excel 1904 date system & MAC issues

September 22, 2010 at 19:05:42
Specs: Windows Vista
The school I work at upgraded to Windows 2007. We've never had any issues with any of the Microsoft Programs; however, this year right when our data was due to the state, many of our Excel Spreadsheets with dates we sent to the main person collecting the data changed. (added 4 years). We found out this person was using a Mac computer. They gave her a district computer running Windows hoping it would solve the issue. I also have been making sure the 1904 Date System box is checked on our documents. It started showing up as uncheck. This has solved the date changing issue at the school, but the other person who has the Mac is still saying our dates change, this time (after ensuring date system box was checked) she said it subtracted 4 years. This person thinks we have a virus and, or we need to reimage our computers. I think she just doesn't understand. We've ran malware, virus scans...nothing. We have also ran a fix on Microsoft Excel. Our tech people also looked at our computers at the school on Monday. They can't find anything either. I'm randomly finding documents that still don't have the 1904 box selected. I've used Excel for over 10 years and I've never had this issue before where I have to keep selecting an option once it's saved. Do you have any ideas what is causing this? The person with the Mac said she tried to go into Excel like I instructured her to do and select the 1904 date box, but she said it gave her an error that she didn't have permission. I don't set security rights so I'm confused about this, too. Several of us have iphones and connect our iphones to the PCs running Windows in order to charge them. Surely, syncing or charging wouldn't cause Excel to revert back to not using the 1904 date sytem? Help would be greatly appreciated!!!

See More: Microsoft Excel 1904 date system & MAC issues

Report •

#1
September 23, 2010 at 07:01:20
Don't know what version of Excel your using, but the first step is probably a Detect & Repair or a Diagnostic:

Excel 2000 & 2003 Detect & Repair:
On the the Task Bar,
Help
Detect & Repair

Excel 2007
Running Microsoft Office Diagnostics from within Excel/Word

Click the Microsoft Office button
Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button
Click All Programs
Click Microsoft Office folder
Click Microsoft Office Tools
Click Microsoft Office Diagnostics
Click Continue
Click Run Diagnostics

You may need the original install media for these.


Also, see here for some work arounds that might be of assistance;

http://support.microsoft.com/kb/180162

MIKE

http://www.skeptic.com/


Report •

#2
September 23, 2010 at 07:04:39
We found out this person was using a Mac computer. They gave her a district computer running Windows hoping it would solve the issue.

but the other person who has the Mac is still saying our dates change,

So are they using a Mac or Windows??

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question