Share via

Sharepoint Time stamp issue

Anonymous
2019-05-29T01:17:03+00:00

Various members of my team saving an excel file with updates however the time stamps on the file don't match when they actually completed the work and saved it back to sharepoint causing confusion as to who did what and when. How do we fix?

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-05-29T02:28:01+00:00

Hi AdminEPMA,

Thanks for posting in our forum. We are glad to help you.

Based on my test, the behavior might be related to the Time Zone and region. The file you uploaded to Teams page is stored in SharePoint Online group site, when you open it in Excel Online, it will use the Time Zone/region from that group site. If group site's time zone/region is different from your computer. It may display a different value in Excel Online.

On your SharePoint online Teams page>File>Open in SharePoint Online>you will be redirected to the SharePoint Online group site page>click Setting gear on the top right>Site Information>View all site settings>Regional settings>Check the Time Zone and locale. If you are the team owner and all other users are in the same time zone and locale as you. Change the value to be the same as your computer. Check the results.

For your reference: Modified time is not displayed correctly for a SharePoint Online list item

Let us know if you need additional assistance.

Best Regards,

Waqas Muhammad

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-05-31T06:12:45+00:00

    Hi AdminEPMA,

    Have you checked my suggestions above? Do you need further assistance?

    Best Regards,

    Waqas Muhammad

    Was this answer helpful?

    0 comments