Excel - Adding new sheets corrupts existing sheets

[Andrew]

When I copy a sheet to the end of a workbook, it changes all of the
data on the existing sheets. Any idea if this bug has been worked out
in recent updates or versions of Excel?

 

[Bob Greenblatt]

When I copy a sheet to the end of a workbook, it changes all of the
data on the existing sheets. Any idea if this bug has been worked out
in recent updates or versions of Excel?

Can you explain in more detail what is happening. This is not a bug or
problem that I am aware of in any version of Excel. What is your
configuration? What is happening to the data when you copy a sheet to the
end?

 

[Andrew]

It's a workbook in Excel X, and when I go to the command "Add or Copy
New Sheet", then select a sheet and copy it to the end of my workbook,
the dates on all 20 of the existing sheets change. There are several
dates (such as 7/2/03) in 25 or so cells on each sheet, and 4 years
are added on to each date. For example, 7/2/03 would change to 7/2/07.
This happens for all of the cells with dates in them, on all of the
sheets in the workbook (4 years are added on). Any ideas? Your help is
much appreciated. Thanks

 

[Bob Greenblatt]

It's a workbook in Excel X, and when I go to the command "Add or Copy
New Sheet", then select a sheet and copy it to the end of my workbook,
the dates on all 20 of the existing sheets change. There are several
dates (such as 7/2/03) in 25 or so cells on each sheet, and 4 years
are added on to each date. For example, 7/2/03 would change to 7/2/07.
This happens for all of the cells with dates in them, on all of the
sheets in the workbook (4 years are added on). Any ideas? Your help is
much appreciated. Thanks

OK, now it's clearer. The DATA doesn't change as stated ion your original
message, but the DATES change. The reason is that the original workbook has
a date preference different than the added sheet. You can change this by
going to the preferences, and on the calculation pane either check (or
uncheck) the 1904 system.

 

[Andrew]

Thanks a lot Bob. I really appreciate your help with this.