• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

Mechanicaleng blog

siemens nx tutorial & injection molding technology

  • Plastic molding
  • Siemens nx
    • nx modeling
    • nx drafting
    • nx sketching
    • nx assembly
  • Mechanical basic
    • mechanical standard
    • Mechanism video
  • microsoft office
    • microsoft word
    • powerpoint
    • excel tips
  • About me
  • CONTACT ME
Home » microsoft office » excel tips » How to fix excel cannot open a file error

How to fix excel cannot open a file error

November 28, 2021 by mechanicaleng blog Leave a Comment

Today, mechanicalengblog.com will guide to you 4 ways to fix excel error cannot open excel file. In this post, you will know the reasons of error and how to fix it.
Have you seen this word: “Excel cannot open the file because the extension is not valid” . Sometimes, we have seen the text “Excel cannot open the file filename.xlsx because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.”

Post contents

  • I. Why excel cannot open a file?
  • II. How to fix error: excel cannot open a file?
    • 1. Change the format extension of excel file.
    • 2. Previous version.
    • 3. Repair excel file by open and repair option.
    • 4. Change the permissions of user.

I. Why excel cannot open a file?

There are some reasons of this error, but I usually met 3 reason below:
+ I receive excel file from other people by email.
+ The document is damaged, incompatible with your current excel version.
+ You have edit and save as your excel file at different version.

II. How to fix error: excel cannot open a file?

1. Change the format extension of excel file.

As default, excel have to extension, *.xlsx and *.xls. If your excel version is older than 2007 version, your excel file will save as *.xls. If your excel version since 2007 save as *.xlsx extension.
So, after receive the excel file, you have to see the extension of this file, if it is newer than your excel version, you cannot open it. How to open it? You can modify the format and test.
– Select file -> options.

excel options dialog
– In the excel options dialog -> select save -> In the save files in this format, select excel workbook and click OK.

2. Previous version.

If the current version of excel cannot open the file, you can test with previous version option.
Right click to your excel file, select Properties -> Previous Version. A list of preview versions will appear, you will select one version that you can open it with your excel software.

excel Previous version option

3. Repair excel file by open and repair option.

If you cannot open your excel file, you test test with open and repair option.
In your excel software, click file -> open -> select open and repair.

fix excel can not open _ open and repair option
Excel will request you select repair or extract date from your file. Select repair options to get the biggest data. If repair option cannot active, select extract data to restore date without formulas.

4. Change the permissions of user.

When you receive excel file from author people, may be you need to set the permissions of user to open it.
– Right click on the excel file and select properties.
– Select security and edit.

excel_properties_security_edit
– In the permission for … dialog, select security and add.

excel permissions for test

– In this select users or groups select advanced.

excel_select users or groups
– Select find now -> everyone and OK.

excel_select users or groups_find now
–

 

Related posts:

Convert word to PDF by microsoft wordconvert word to PDF file online for free reduce size in excel _compress pictures in excel4 ways to reduce excel size Using CONCATENATE commandHow to add leading zeros in excel Open Word Files in Older Versions of Microsoft Office Word 13 ways to open word files in older versions of ms Word

Filed Under: excel tips Tagged With: excel beginner

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • what is spur gear | introduction
  • Mechanical engineering skills from training process
  • What is Inox | Stainless Steel?
  • How to create thread in nx
  • nx assembly| create a new part from the same part
  • how to calculate sum of squares in Excel
  • How to active GC toolkits in Siemens NX
  • How to create a sphere in nx
  • How to create a cone in nx
  • How to create a cylinder in nx

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in