Sharepoint shows wrong data opening an Excel group of files (preview and edit mode)

Irving Edilberto Chavarría 0 Reputation points
2023-03-06T16:27:55.26+00:00

When opening certain Excel files in Sharepoint, the information is shown wrong in Preview and Edit Mode. If I go through the cells the information is displayed in the formula bar. If I open the file with the Excel App there is no problem. I attached a screenshot.

It only happens on three users and I already cleared the browsers cache, and the problem persists.

Can anyone help me with this problem?Datos corruptos SharePoint 1

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
287 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
6,457 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 26,636 Reputation points Microsoft Vendor
    2023-03-07T09:50:56.16+00:00

    Please follow below tips to troubleshoot the issue.

    1.Check personal language and time zone settings of users who reported the issue. Click My Microsoft 365 profile -> Language and time zone.

    2.Check language and time zone settings of the site collection where the excel file stored. Go to Site settings -> Language settings.

    3.Check local computer language settings. Go to Control Panel -> Clock and Region.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread