In the morning excel On the worksheet , I found that I couldn't open it after I finished building it

Tips :

Nima is such a fool , Is it my fault Excel broken ??

After checking the problem, we found that Only new “Microsoft Excel Worksheet ” This kind of problem will appear when we are in the market , newly build “Word”、“PPT”、“Microsoft Excel 97-2003 Worksheet ” No problem , Open separately Excel It's OK to select a new worksheet in it , There is something wrong with the newly created file .

So he began to ask for help from Du Niang , Take a look , o ! There are a lot of guys who have had this kind of problem ... I'm very pleased , Start to try all kinds of methods according to the Internet ... And then there are all kinds of things that don't work

For example, modify the registry HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command

For example, modify Excel Add INS for

For example, modify Excel The template of

....

However, it doesn't make any difference

So I started using the ultimate trick ! reinstall + restart

And then it turns out that there's no egg use ....

ok All of them on the Internet are unreliable , It's up to you at the critical moment

Analyzed it carefully , open Excel You can create a new sheet , You can also open other .xlsx file , There is something wrong with the software itself , And new “Microsoft
Excel 97-2003
Worksheet ” It can also be opened normally , The difference between the two is the difference between the new and old versions of the template , But certainly not because of the incompatibility between the old and new versions ( Because Baidu before when online friends said that the solution to this problem , It's no use changing it ), All that's left is to select a template when creating a new file !!!

Find out the problem , Let's start looking for solutions , But after trying various custom templates, it still hasn't been solved ... Lose heart

What a nuisance .

But the goddess of luck still abandoned me , Just when I want to give up , Suddenly I saw someone ask this question on Microsoft's official website , Links are as follows :

office2016 Can't open right mouse button new excel file , Other forms can be opened

Someone inside said such a way ( Of course, this method still can't work ):

1. Press WIN+R, function regedit, Open registry editor
2. And then in HKEY_CLASSES_ROOT Find below .xls and .xlsx, Right click New - term , Name it shellNew, Then create a new - character string , Name it NullFile, Value is empty

And then I'll follow this to start a new one ..., Just before I started .xlsx When it comes to this , Suddenly found that there has been shellNew 了 , But the path is different from what he said , But inside FileName It's all pointing to Office Template directory for

Let's take a look , Find out .xls The lower one ShellNew Of FileName The value of is used before WPS Of , But WPS Uninstalled , And the problem is *.xlsx, Not yet *.xls, Then leave it alone

And then turn it on again .xlsx The lower one ET.Xls.6 The lower one ShellNew, Found here FileName The value of is also WPS Of , It was before WPS Template path for , Copy path to file explorer open , Found no path . By this time, I had a general idea of what was going on . Then open the Excel.Sheet.12 The lower one ShellNew, The same as usual , assignment FileName Value , I found it opened , It opens a blank Excel file , file name :excel12.xlsx, This should be Excel The template file of , Copy and paste this path into ET.Xls.6 The lower one ShellNew Of FileName, Change the original value to “C:\Program
Files (x86)\Microsoft
Office\Root\VFS\Windows\ShellNew\excel12.xlsx”,OK, Back to the desktop , Right click > newly build >Microsoft
Excel Worksheet , Double click to open !!!

The reason is that before the new “Microsoft Excel Worksheet ” When , Templates are used WPS The template of , But this template can't be found , So there's a problem with the new worksheet , Lead to Excel Cannot be opened .

terms of settlement : Modify the image above ET.Xls.6 > ShellNew > FileName Value , It is amended as follows Excel Own template path , Fix up the work

Excel2016 Right click new sheet , Prompt when opening “ Because the file format or file extension is invalid . Please make sure the file is not corrupted , And the file extension matches the file format .” More related articles on the solution of

  1. C# export Excel file Prompt when the exported file is opened “Excel The file format is inconsistent with the format specified by the extension ”

    Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); ...

  2. vs2013 Install flashback and vs2010 vs2013 Prompt when opening Failed operation And vs2013 Flash back after the picture appears during installation

    vs2013 The prompt when opening is as shown in the figure above ,vs2010 Only   Failed operation   A hint like this . At this time .net 4.0 There is no response when the developed program is opened , Should be .net framework Something went wrong. . Look at the control panel - Uninstall program , Find out ...

  3. eclipse Prompt when opening :failed to create the java virtual machine

    Eclipse Prompt when opening : failed to create the java virtual machine reason :C Not enough disk space   Edit delete Handle :1. Use Jinshan to clean up temporary documents : 2. Connect with Jinshan mobile guard ...

  4. WordPress Prompt when new users register “ Your password reset link is invalid ”

    In the use of Wordpress Password recovery function and reset password link in new user registration email ,Wordpress Tips “ Your password reset link is invalid , Please request a new link below .”.“ The key It doesn't seem to work ”.“invalid key”. This is its ...

  5. About asp.net C# export Excel file open Excel The solution to the inconsistency between the file format and the format specified by the extension

    ----- Reprint :http://blog.csdn.net/sgear/article/details/7663502 About asp.net C# export Excel file open Excel File formats and extensions refer to the grid ...

  6. Android Studio Prompt when opening ADB Wrong question

    As shown in the figure ,ADB Connection error , The solution is simple : open cmd, Locate the sdk Under folder platform-tools, And then execute adb kill-server enter : Re execution adb start-server that will do

  7. Oracle Prompt when editing data : These query results are not updatable , Please use ROWI perhaps SELECT……FOR UPDATE Get updatable results

    We are in the Oracle Database operation , Sometimes you want to operate some of the data after the query is finished , When we click Edit ( A lock sign ) yes , It will prompt us to make mistakes in the above questions : These query results are not updatable , Please use ROWI perhaps SELECT ...

  8. Right click notepad++ Prompt when opening , ShellExecute failed (2): Is this command correct?

    The error is shown in the following figure : resolvent : Right click notepad++.exe; Get rid of the administrator mode

  9. maven project in , stay main Right click on the method Run as Java Application when , Prompt error : Cannot find or load main class XXX.XXXX.XXX

    I've created a new one maven project project , After a lot of modification , Suddenly found in main Method , Even hint : error : Cannot find or load main class xxx.xxx.xxx Possible causes 1.eclipse Something is wrong. , stay ...

Random recommendation

  1. ios Project reference global pch file

    1. Add... To the project PCH file Write these down , Next time just paste :$(SRCROOT)/ project name /pch file name

  2. javabean summary

    One . javabean What is it? ? Bean The Chinese meaning of “ Bean ”, seeing the name of a thing one thinks of its function ,JavaBean It means a special period of time Java class , There is a silent construction method , Only get,set The method of java Class object . The professional explanation is : ...

  3. sybase convert function

    1. from string To int Transformation convert(int,@string) select convert( int , '15') 2. from int To decimal Transformation convert(deci ...

  4. nginx Website architecture optimization ideas ( primary )

    I contact the optimization is mainly divided into three categories The focus of this module is in bold  --------------- Security optimization Safety comes first in the production scenario 1.1 Optimization of site directory permissions ( Modify the permissions 755 644 Users root, need ...

  5. Hi, Big Ben \\ u0026 universal , Microsoft's open source

    glossary -- Hi, Big Ben \\ u0026 universal : To have loved . Fun games , Celebrate . rush about telling the news around spreading . In short <reload=1"> Microsoft announces .NET Open source development environment > It's good news . Foreword and historical recollection As far as I'm concerned ...

  6. Do it yourself spring Containers (1)

    Just over a year after graduation , After graduation, I successfully entered a famous Internet company , It's a back office system , It's also used SSI(struts2,spring) frame , Usually do projects , That's enough , But I feel less and less motivated , Less and less passion ...

  7. Use StringEscapeUtils Yes Java Escape and anti escape of special characters in

    https://blog.csdn.net/zdx1515888659/article/details/84966214 Java Middle escape character backslash \ Instead of | repalceAll Connotation analysis ...

  8. Detailed interpretation Android Search box in ( Two )—— Search Dialog

    Search Dialog Is one of the controls that provides search , There is also a small example given last time searchView, About SearchView I'll talk about it later . This time we will start with Search Dialog Speaking of , Let's understand andr ...

  9. 【 turn 】10 A very useful web design tool | Goodfav Magazine

    10+ very useful Web Designer Tools Totally free legal computer eBooks download, available in various ...

  10. Do... On the picture X,Y Axis turning , Black and white

    Finished the procedure of modifying the picture . With Winfrom It's done . It was basically finished yesterday , Record what you use . The first is to put the image to be loaded into picturebox Control , It's used here openfiledialog  Open the file dialog strin ...