Tools==Options=Calculations=1904 Date System (Check/uncheck as required)

Suggests source has 1904 Date System checked and target is unchecked.

HTH



"man818" wrote:

When I copy a spreadsheet to another workbook, the data values all change by
4 years backward.