I can't open my excel file...

Sunho Cho 1 Reputation point
2020-09-16T08:02:58.09+00:00

Whenever I open an Excel file, the following sentence appears and the file does not open.
"파일 형식 또는 파일 확장명이 잘못되어 '00.xlsx'파일을 열수 없습니다.파일이 손상되지 않았는지, 파일 확장명이 파일 형식과 일치하는지 확인하십시오."
"Could not open file '00.xlsx' because of the wrong file type or file extension. Please make sure the file is not corrupt and that the file extension matches the file type."

Please help me...

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,639 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 Reputation points
    2020-09-17T07:50:14.513+00:00

    @Sunho Cho ,
    Could you please tell me what version of Office are you using now?

    How did you create these workbooks?
    It's recommended to create new blank workbooks in Excel to have a test.
    Open Excel desktop application first > New > Choose blank workbooks, then edit, save it and open it.

    1 If this issue does not occur with files created in Excel and occurs with files created by right-clicking, please follow the steps below to check a registry key data.
    (Please note, serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.
    Please refer to this article about how to back up and restore the registry in Windows: https://support.microsoft.com/en-us/kb/322756)

    There is an Office 365 (64-bit) installed on my test environment, and I would use it as an example.

    • Type "regedit" in Run dialog, press Enter.
    • Then locate to Computer\HKEY_CLASSES_ROOT\.xlsx\Excel.Sheet.12\ShellNew, check the Data at right panel, make sure the data value is a .xlsx file. If not, you need to modify the value.
      On my test environment, the value is C:\Program Files\Microsoft Office\Root\VFS\Windows\Shellnew\excel12.xlsx.

    2 If no matter what method is used to create new workbooks, this issue would persist.

    • Please backup some of these files first, go to File explorer > View in Show/hide group > check the box of "Hidden Items".
      Then modify the extension, such as .xls to have a check.
    • Run Excel in safe mode to open files. Enter "excel /safe" and click OK. Then open files check whether this issue reproduced.
      If not, you may go to File > Options > Add-ins > Manage, COM Add-ins, clear the check boxes for any enabled COM add-ins, select OK.
    • Repair Office on Control Panel.

    Any questions, please let us know.

    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.

    0 comments
  2. Zorro Ronoroa 1 Reputation point
    2021-04-15T09:50:34.65+00:00

    This is a usual error due to invalid file extension. This is mainly caused due to the following reasons:
    • The file is no longer compatible with the MS Excel version
    • The Excel file is corrupt or damaged
    Here is a workaround which can be used in such situations:

    Method 1 – Change the Default File Format to Save Excel Workbooks
    • In Excel, click on the ‘Microsoft Office’ button and then ‘Excel Options’.
    • Select the Export option.
    • Tap on Change File Type option.
    Method 2 – Use 'Open and Repair' Feature of MS Excel
    • Open the MS Excel.
    • Navigate to File and Select the Open option.
    • Select the corrupt file and choose Open and Repair option.
    • Click Repair to start repairing the file.
    You can also read this thread:
    https://social.technet.microsoft.com/Forums/office/en-US/63020ccc-51d7-46d9-b956-121c0e6efcc8/excel-file-error-the-file-format-and-extension-dont-match?forum=Office2016ITPro

    0 comments