excel messy code

陈墨 1 Reputation point
2021-03-05T07:11:43.977+00:00

everytime I tried to open an excel fire uploaded from my company's ERP system, it comes up with messy code and I can't fix it. what should I do?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,596 Reputation points
    2021-03-09T10:34:23.66+00:00

    @陈墨
    Which version of Excel are you using to open these excel files?
    Did you open the Excel file via browser or Excel desktop client?

    Please note, tag "office-excel-itpro" on Q&A forum focus more on general issues of Excel desktop clients.
    If the workbooks opened via Excel desktop clients are changed to be messy code, please go to Control Panel > Clock and Region > Region > Administrative > Change System locale, you may choose a language which is same as the language used on Excel files.

    Besides, it's recommended to repair workbooks, more detailed information, please refer to "Repair a corrupted workbook".


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.

    1 person found this answer helpful.
    0 comments No comments