question

18669412 avatar image
0 Votes"
18669412 asked ·

excel messy code

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?

office-excel-itpro
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Adding right tags/teams to assist.

0 Votes 0 ·

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered ·

@18669412
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.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.