excel messy code

陈墨 1 Reputation point

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

    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