WHY DOES IT SAY FILE FORMAT IS INVALID WHEN YOU OPEN EXCEL

Windows7 Documents and Settings are set up to improve their compatibility,Although there is a way to obtain system permissions on the Internet,But I recommend not modifying,Because the system permission is the highest authority,Higher than the super administrator permission,That is, the files of the system can be changed,I think this is not necessary for the average user。 Access rights are set to enhance the security of the system, and this mechanism has been introduced since Vista.

So how do you find the files that were previously created in XP Documents and Settings in Windows 7?

Start by opening the Control Panel in the Appearance & Personalization folder options to view the Hide System Protected Files (remove the Show Hidden Files) OK. Open the disk where the system is located, and find that there are a lot of hidden ones. Find the "Users" folder, go to the relevant account, and find AppData, which contains the roaming file that was previously created in the documents and settings under XP.

I've also encountered this situation because the excel file you want to open is damaged and cannot be recovered, so it is invalid. Only re-copied from somewhere else, and then continued.

It may be that macros are enabled, or it may be encrypted.

What should I do if the message "Invalid file format" is displayed when the excel file is opened?

Hello, dear I am Xiaoqiang, a life coach, and I am very happy to be able to answer for you. When the excel file is opened, it prompts "invalid file format", usually for the following reasons:1

The file is corrupted. The file can be corrupted during storage or transfer, resulting in format corruption and inability to open. In this case you can try to repair the excel file

Open Excel, click "File" "Options" "Recover" "Recover Unsaved Workbook". Select the file you want to repair and click "Recover" to see if you can repair it. If the above methods can't fix it, you can use a third-party tool to fix it.

For example, use tools such as "Repair My Excel" or "Recovery Wizard" to try to repair and then open it. 2.Open the file version with an overvolt grip high or too low.

This prompt will also appear if the file was generated by a newer version of Excel and your current Excel version is too low. In this case, please upgrade your Excel version before opening the file. On the contrary, if the file is generated by an earlier version of Excel, the current higher version of Excel is not fully compatible, and the message "Invalid file format" will also be displayed.

If the file extension is incorrectly changed to a non-excel extension, Excel will not recognize the file format and the message "Invalid" will be displayed. In this case, the extension can be modified to the correct ".".xls" or "

xlsx", excel should open normally. 4.The file encoding is incompatible.

If the file is saved with some special encoding that your Excel does not recognize, the file will not be opened. Try saving the file as "ANSI", "UTF-8", or "Unicode" encoding and reopening it. 5.

The file has been encrypted. If the file is encrypted in advance, excel will not be able to open without the unlock password, and the format will be invalid. In this case, you will need to enter the correct password to open the file.

<>2. Select the second item "View" in the dialog box, and find "Hide extensions of known file types" in the advanced options and remove the previous checkbox. Now we can see the file suffix, right-click on the file "Rename" to change the file suffix to "xls".

3. After changing it, take a look at it, and the file can be opened.

Excel can't open the prompt file format is invalid solution steps:

First, first we open "This Computer", then we find the "File" option in the upper right corner of the "This Computer" page, and we click on it.

<>3. Then we select the "View" option in the menu bar in the "Change Folder & Search" dialog box, and then we find the "Hide extensions of known file types" option in the advanced settings. Let's uncheck the box in front of "Hide extensions of known file types".

Fourth, then we click on the "Apply" option at the bottom of this page. Then we go back to the desktop.

5. After returning to the desktop, we can see the suffix of this excle file, and then we right-click on the file to "rename" and then we change the file suffix to "xls".

6. Next, we can open this excle file normally.

Solution: Excel prompts "Invalid file format":

1. (Take win10 system as an example) open "This computer (win7 system is my computer)" and find "File" in the upper right corner and click it.

3. Select the second item "View" in the dialog box, find "Hide extensions of known file types" in the advanced settings and remove the previous checkbox.

4. Click Apply.

5. Now that you can see the suffix of the file, right-click the file "Rename" to change the file suffix to "xls".

6. After changing it, take a look at it, and the file can be opened.

The Excel file format or extension is invalid, it is related to the installation of WPS software on the computer, and the Excel registry needs to be modified to solve the problem, the solution is as follows:

1. The first step is to use the win+r shortcut key to call up the run, enter regedit, and click OK.

2. Step 2 and then launch the registry.

3. In the third step, you can open it in turn: hkey classes rootxls, double-click ab (default) in the right sidebar, and change "numeric data" to "OK".

4. In the fourth step, open it again in turn: hkey classes rootxlsx, double-click ab (default) on the right sidebar, change "numeric data" to ", and finally click OK.

5. The fifth step, take a look at it after the change, and the excel file can be opened.

You can try to recover the file while you open it, follow the steps below.

Tool: Excel2010.

1. Click the file button in the upper left corner of Excel2010 software.

2. Click the Open button in the left toolbar.

3. Select the file you want to process, and then click the black triangle on the right side of the open button.

4. After clicking the triangle, the menu will pop up, click Open and Fix on the menu.

5. At this time, the menu will pop up, click the repair button on the left.

6. After the repair is completed, the pop-up window will appear, click Close below.

1. First of all, you need to confirm whether this excel** is a real excel**.

2. Sometimes a new WPS file is forcibly changed to a suffix called an excel file, and after opening, it will prompt as shown in the figure below, if you want to open such a file, you must know its original format, and then restore the suffix, and use the relevant software to open it.

3. There is also a situation in xlsx format, if you want to open the excel file in this format, there are many ways, you can **compatible package, you can also upgrade excel software to 2007 or 2010, you can open the excel text ending in xlsx suffix.

4. If it is confirmed that excel** is true, and it is not a problem with the version, it may be a problem with the excel software, so it is necessary to confirm whether it is a virus that destroys the excel software, causing the software to not work normally, and carry out a full virus detection and killing to see if it can solve the problem, and the virus detection and killing effect will be better in safe mode.

5. Use the disease with cluster poison directly on the 360 security guard to detect whether you are infected by the virus.

<>2. Select the second item "View" in the dialog box, and find "Hide extensions of known file types" in the advanced options and remove the previous checkbox. Now we can see the file suffix, right-click on the file "Rename" to change the file suffix to "xls".

3. After changing it, take a look at it, and the file can be opened.

What should I do if the message "Invalid file format" is displayed when the excel file is opened?

Hello, I am glad to serve you and give you the following answer: when the excel file is opened, the search prompts "invalid file format", which may be caused by the file being corrupted or the file format is incorrect. First, you can try re-creating the file and see if it opens properly.

If it still doesn't open, you can try opening it with other software, such as LibreOffice or OpenOffice, to see if it opens properly. If it still won't open, you can try Excel's "Recover" feature and see if you are able to recover the files. If you still can't recover it, you can try Excel's "Repair" function to see if you can repair the file.

If you still can't fix it, you can try using a third-party software, such as StellarphoenixExcelRepair, to see if it can repair the file. If it still can't be repaired, you can try using Excel's "Save As" function to save the file in another format and see if it can be opened normally.