How can I fix a sharepoint excel file that opens in gibberish to normal text?

Anonymous
2023-01-17T12:59:35+00:00

We are using shared reports from a sharepoint having the convenience of accessing these reports via browser. But a few days ago, certain users are having problems with these reports, because when they access them, they see gibberish rather than normal text. This does not happen when its opened on the desktop app, only when its opened on the browser.

How can I fix this?

Microsoft 365 and Office | Excel | 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

43 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2023-01-17T13:44:16+00:00

    Hi Daniel,

    Greetings! Thank you for posting to Microsoft Community.

    Have you tried change the text format to another one? It should be correct the display of it.

    Most of this issue could be caused by encoding, but in cells it show correct value. So it should be text format settings on your workbook.

    Best Regards,

    Snow Lu

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-01-17T15:22:04+00:00

    I tried it, it doesn't work.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-01-17T15:40:58+00:00

    Could you share us the file and remove all sensitive information in it?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-01-18T09:12:10+00:00

    Have you tried double click on one cell? Will the data come back to normal?

    If it can be display correctly, then you can format painter for all other cells.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2023-01-25T17:14:03+00:00

    This is happening in my organization as well. The issue only occurs in OWA. In some instances, it will change to the appropriate text when the magnification level is changed, or some other property is changed. And I cannot replicate the issue in that moment, once it changes back to normal.

    My entire organization uses OWA and very commonly previews files in-browser. This will be very confusing for them. We did not change any settings in our admin/org portal. Is it possible that something in this month's Microsoft Patch Tuesday has resulted in this issue?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments