前面介绍了Excel打开报错 0xc0000022的解决办法,方法请点击连接:
https://blog.csdn.net/qq_26741933/article/details/111225800
但是发现打开表格全部是灰色,需要点击"文件"--“打开” 选择文件位置才能打开:
![](https://img-blog.csdnimg.cn/20201219153433783.png)
![](https://img-blog.csdnimg.cn/20201219153540608.png)
需要修改注册表:
1.按Windosw + R 快捷键,运行框 输入 regedit;依次找到:HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command
![](https://img-blog.csdnimg.cn/2020121915394397.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NzQxOTMz,size_16,color_FFFFFF,t_70)
![](https://img-blog.csdnimg.cn/20201219154124562.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NzQxOTMz,size_16,color_FFFFFF,t_70)
![](https://img-blog.csdnimg.cn/20201219154200962.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NzQxOTMz,size_16,color_FFFFFF,t_70)
右键单击如下"command" 修改,在数值数据后面增加:空格 "%1" ,确定即可!
注意e字母后面空格,不要换行
![](https://img-blog.csdnimg.cn/2020121915425352.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NzQxOTMz,size_16,color_FFFFFF,t_70)
![](https://img-blog.csdnimg.cn/20201219154437211.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2NzQxOTMz,size_16,color_FFFFFF,t_70)