SharePoint Document Issues

How to Understand Creation Times for Duplicated Excel Files in SharePoint

Huma Ashraf Ch Sep 29, 2026 869 views

Question details

The user needs to understand how SharePoint records creation and modification timestamps when duplicating a worksheet inside an Excel workbook versus copying the entire workbook to another site.

How to Understand Creation Times for Duplicated Excel Files in SharePoint

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Determining the original creation date and the copied date for Excel files and worksheets within a SharePoint environment.
Observed behavior: Duplicating a worksheet changes the file's modified date but not the creation date, while copying a workbook to a new SharePoint site creates a new file ID with a completely new creation timestamp.

Before you start

Ensure you have at least 'Read' or 'View Only' permissions in your SharePoint document library to access the file's version history, details pane, and metadata columns.

Solution 1Recommended

Determine Timestamps Based on the Duplication Method

Learn the technical difference in SharePoint timestamp tracking between duplicating a tab inside an existing file versus copying the entire file across sites.

SharePoint tracks document timestamps based on the object's unique ID. The scope of your duplication dictates whether SharePoint registers the action as a file edit or the creation of a brand new file.

Check worksheet duplication

If you duplicated a worksheet tab inside an existing Excel workbook, SharePoint considers this an edit to the file. When you save and close, the 'Modified' column updates, but the 'Created' date remains completely unchanged.

Check file copying across sites

If you copied or uploaded the entire Excel workbook into a different SharePoint site or library, SharePoint treats this as a brand-new entry. It assigns a new file ID and the 'Created' date will display the exact date and time the file entered the new SharePoint environment.

Determine Timestamps Based on the Duplication Method

Solution 2

Check Internal Version History and Embedded Metadata

Use SharePoint's version history and Excel's internal document properties to find the true origin of a document.

Free Microsoft Office alternative

Manage Spreadsheets Offline and Online with WPS Office

While SharePoint handles file tracking on the web, having a reliable desktop office suite is essential for managing properties locally. WPS Office offers a free, lightweight alternative to Microsoft Office, fully compatible with all your Excel workbooks (.xlsx). It features a familiar interface, allowing you to edit, duplicate worksheets, and check internal document creation timestamps with zero learning curve.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your .xlsx workbook directly from your local synced SharePoint folder or hard drive.
2. Access the main menu: Click on the 'Menu' button located at the top-left corner of the application interface.
3. View internal document properties: Select 'Document Information' to view the internal creation, modification, and access dates embedded within the file itself.

Fully compatible with Microsoft Excel (.xls, .xlsx, .csv) formats.Free and lightweight office suite for PC, Mac, and mobile devices.Familiar tabbed user interface ensuring a seamless migration.Easily view local document properties and metadata offline.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my copied SharePoint file show today's date as the creation date?

When you copy a file to a new SharePoint site or document library, SharePoint treats it as a newly created object in that specific location. It is assigned a new system ID, and the 'Created' timestamp reflects the exact moment the copy was generated in the destination folder.

How can I find the original creation date of a copied Excel file?

To find the original creation date, you need to check the file's embedded metadata rather than SharePoint's library columns. Open the file in your desktop spreadsheet application (such as Excel or WPS Office), navigate to the 'File' or 'Menu' tab, and check the 'Document Properties' or 'Info' section for the embedded creation date.

Does duplicating a worksheet tab change the workbook's version history?

Yes. Duplicating a worksheet tab inside an existing workbook constitutes a modification to the file. When the autosave triggers or you manually save the document, SharePoint will update the 'Modified' timestamp and generate a new version in the document's version history, though the 'Created' date stays the same.

Document & File Issues