1、microsoftexcel表格里点右键怎么没有超链接竭诚为您提供优质文档/双击可除microsoftexcel表格里点右键怎么没有超链接篇一:excel20xx里不能使用超链接excel20xx里不能使用超链接,提示“由于本机限制,无法使用”今天使用excel20xx时发现一个问题,打开excel文件,工作表内之前建的超级链接不能使用,点击是提示“由于本机限制,无法使用,请与管理员联系”。一个小时前建工作表的时候,超级链接还是正常的,中间重启了一次电脑,就成这样了,重启前清理了一次系统垃圾,上网搜资料开始解决。经过搜索,网上给出了三个参考方案:a方案,.打开word或excel,菜单里选择“
2、工具自动更正”,单击“键入时自动套用格式”选项卡,勾选“internet及网络路径替换为超级链接”复选框(如果已勾选,则取消)。重新打开word/excel或是outlook,你将发现,问题解决!b方案(如果a方案不能解决,可以试试下面这条)打开“ie浏览器”-internet属性-点开“程序”选项卡中,点击“重置web设置”。重新打开word/excel或是outlookok!c方案,如果你之前装过遨游浏览器,那就是注册表被修改了。所以是注册表的问题。解决办法如下:1.打开开始菜单,在运行里输入regedit,回车2.在注册表中,导航到hkey_cuRRent_useRsoftwarecla
3、sses.html项3.在默认项上点右键选择修改4.将max2.association.html值改为htmlfile,然后确认,然后退出注册表5.重启你正在使用的excel,然后再次点office里面超链接,备注:如果是其他浏览器的问题或者没有.html项的话,就新建一个.html,然后把键值改为htmlfile,确认再退出注册表就可以了。按照三个方案依次执行,a,b方案都没有解决问题,在看c方案时,中间提到了遨游浏览器,我的电脑通过云端安装了遨游浏览器,平时开机启动云端,但是不启动遨游,怀疑是云端没有开启的缘故。开启云端后,重新打开excel,超级链接回复正常,关闭云端,故障依旧。然后开启
4、云端再次执行方案b,方案a已经执行过。将ie设置为默认浏览器,再关闭云端,打开excel,超级链接恢复正常。c方案自始至终没有执行,问题解决后检查了一下注册表,其中没有问题,不知道出问题的时候里面是什么样的。网上还有一个方法是新建注册表文件进行导入,不过没有测试过,不知道风险大不,将代码给大家写到下面,有兴趣的朋友可以试一下。打开一个记事本,复制下列内容,然后另存为.reg文件,然后双击导入:windowsRegistryeditorVersion5.00hkey_classes_Root.htmperceivedtype=text=htmlfilecontenttype=text/htmlh
5、key_classes_Root.htmopenwithlisthkey_classes_Root.htmopenwithlistexcel.exehkey_classes_Root.htmopenwithlistexcel.exeshellhkey_classes_Root.htmopenwithlistexcel.exeshelledit=&openhkey_classes_Root.htmopenwithlistexcel.exeshelleditcommand=c:programFilesmicrosoftofficeoffice12excel.exe/ecommand=hex(7):
6、76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,00,61,00,54,00,4f,00,
7、35,00,20,00,2f,00,65,00,00,00,00,00hkey_classes_Root.htmopenwithlistexcel.exeshelleditddeexec=open(%1)hkey_classes_Root.htmopenwithlistexcel.exeshelleditddeexecapplication=excelhkey_classes_Root.htmopenwithlistexcel.exeshelleditddeexectopic=systemhkey_classes_Root.htmopenwithlistmicrosoftofficeexcel
8、hkey_classes_Root.htmopenwithlistmicrosoftofficeexcelshellhkey_classes_Root.htmopenwithlistmicrosoftofficeexcelshelledit=&openhkey_classes_Root.htmopenwithlistmicrosoftofficeexcelshelleditcommand=c:programFilesmicrosoftofficeoffice12excel.exe/ecommand=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00
9、,21,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,00,61,00,54,00,4f,00,35,00,20,00,2f,00,65,00,00,00,00,00hkey_c
10、lasses_Root.htmopenwithlistmicrosoftofficeexcelshelleditddeexec=open(%1)hkey_classes_Root.htmopenwithlistmicrosoftofficeexcelshelleditddeexecapplication=excelhkey_classes_Root.htmopenwithlistmicrosoftofficeexcelshelleditddeexectopic=systemhkey_classes_Root.htmopenwithlistmicrosoftofficepublisherhkey
11、_classes_Root.htmopenwithlistmicrosoftofficepublishershellhkey_classes_Root.htmopenwithlistmicrosoftofficepublishershelledit=&openhkey_classes_Root.htmopenwithlistmicrosoftofficepublishershelleditcommand=c:programFilesmicrosoftofficeoffice12mspub.exe%1command=hex(7):76,00,55,00,70,00,41,00,56,00,35,
12、00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,50,00,75,00,62,00,50,00,72,00,69,00,6d,00,61,00,72,00,79,00,3e,00,74,00,57,00,7b,00,7e,00,24,00,34,00,51,00,5d,00,63,00,40,00,3f,00,46,00,40,00,36,00,6b,00,78,00,61,00,54,00,4f,00,35,00,20,00,25,00,31,00,00,00,00,
13、00hkey_classes_Root.htmopenwithlistmicrosoftofficewordhkey_classes_Root.htmopenwithlistmicrosoftofficewordshellhkey_classes_Root.htmopenwithlistmicrosoftofficewordshelledit=&openhkey_classes_Root.htmopenwithlistmicrosoftofficewordshelleditcommand=c:programFilesmicrosoftofficeoffice12winwoRd.exe/n/dd
14、ecommand=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,57,00,4f,00,52,00,44,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,24,00,34,00,51,00,5d,00,63,00,40,00,35,00,64,00,31,00,60,00,2c,00,78,00,61,00,54
15、,00,4f,00,35,00,20,00,2f,00,6e,00,20,00,2f,00,64,00,64,00,65,00,00,00,00,00hkey_classes_Root.htmopenwithlistmicrosoftofficewordshelleditddeexec=Rem_dde_directFileopen(%1)hkey_classes_Root.htmopenwithlistmicrosoftofficewordshelleditddeexecapplication=winwordhkey_classes_Root.htmopenwithlistmicrosofto
16、fficewordshelleditddeexectopic=systemhkey_classes_Root.htmopenwithlistmspub.exehkey_classes_Root.htmopenwithlistmspub.exeshellhkey_classes_Root.htmopenwithlistmspub.exeshelledit=&openhkey_classes_Root.htmopenwithlistmspub.exeshelleditcommand=c:programFilesmicrosoftofficeoffice12mspub.exe%1command=he
17、x(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,50,00,75,00,62,00,50,00,72,00,69,00,6d,00,61,00,72,00,79,00,3e,00,74,00,57,00,7b,00,7e,00,24,00,34,00,51,00,5d,00,63,00,40,00,3f,00,46,00,40,00,36,00,6b,00,78,00,61,00,54,00,4
18、f,00,35,00,20,00,25,00,31,00,00,00,00,00hkey_classes_Root.htmopenwithlistnotepad.exe=hkey_classes_Root.htmopenwithlistwinword.exehkey_classes_Root.htmopenwithlistwinword.exeshellhkey_classes_Root.htmopenwithlistwinword.exeshelledit=&openhkey_classes_Root.htmopenwithlistwinword.exeshelleditcommand=c:
19、programFilesmicrosoftofficeoffice12winwoRd.exe/n/ddecommand=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,57,00,4f,00,52,00,44,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,24,00,34,00,51,00,5d,00,63,00
20、,40,00,35,00,64,00,31,00,60,00,2c,00,78,00,61,00,54,00,4f,00,35,00,20,00,2f,00,6e,00,20,00,2f,00,64,00,64,00,65,00,00,00,00,00hkey_classes_Root.htmopenwithlistwinword.exeshelleditddeexec=Rem_dde_directFileopen(%1)hkey_classes_Root.htmopenwithlistwinword.exeshelleditddeexecapplication=winwordhkey_cla
21、sses_Root.htmopenwithlistwinword.exeshelleditddeexectopic=systemhkey_classes_Root.htmpersistenthandler=eec97550-47a9-11cf-b952-00aa0051fe20hkey_classes_Root.htmlperceivedtype=text=htmlfilecontenttype=text/htmlhkey_classes_Root.htmlpersistenthandler=eec97550-47a9-11cf-b952-00aa0051fe20hkey_classes_Ro
22、othtmlfileappusermodelid=microsoft.internetexplorer.default=htmldocumentFriendlytypename=c:windowssystem32ieframe.dll,-912hkey_classes_Roothtmlfilescripthostencode=0cF774d0-F077-11d1-b1bc-00c04F86c324hkey_classes_Roothtmlfileshell=opennewhkey_classes_Roothtmlfileshelledit=&edithkey_classes_Roothtmlf
23、ileshelleditcommand=c:programFilesmicrosoftofficeoffice12msohtmed.exe%1hkey_classes_Roothtmlfileshellopen=openins&amewindowmuiVerb=c:windowssystem32ieframe.dll,-5732hkey_classes_Roothtmlfileshellopencommand=c:programFilesinternetexploreriexplore.exe-nohomehkey_classes_Roothtmlfileshellopenddeexec=fi
24、le:/%1,-1,noactivatehandler=hkey_classes_Roothtmlfileshellopenddeexecapplication=iexplorehkey_classes_Roothtmlfileshellopenddeexectopic=www_openuRlhkey_classes_Roothtmlfileshellopennew=&openmuiVerb=c:windowssystem32ieframe.dll,-5731hkey_classes_Roothtmlfileshellopennewcommand=c:programFilesinternete
25、xploreriexplore.exe%1hkey_classes_Roothtmlfileshellopennewddeexec=%1,-1,0,noactivatehandler=hkey_classes_Roothtmlfileshellopennewddeexecapplication=iexplorehkey_classes_Roothtmlfileshellopennewddeexecifexec=*hkey_classes_Roothtmlfileshellopennewddeexectopic=www_openuRlnewwindow篇二:excel无法打开超链接excel20
26、xx里不能使用超链接,提示“由于本机限制,无法使用”今天使用excel20xx时发现一个问题,打开excel文件,工作表内之前建的超级链接不能使用,点击是提示“由于本机限制,无法使用,请与管理员联系”。方案一,打开word或excel,菜单里选择“工具自动更正”,单击“键入时自动套用格式”选项卡,勾选“internet及网络路径替换为超级链接”复选框(如果已勾选,则取消)。重新打开word/excel或是outlook,你将发现,问题解决!方案二,如果一方案不能解决,可以试试下面这条打开“ie浏览器”-internet属性-点开“程序”选项卡中,点击“重置web设置”。重新打开word/exc
27、el或是outlookok!方案三我的方法是:运行程序Regedit,在注册表打开以下目录hkey_cuRRent_useRsoftwareclasses.html,将其默认的数值数据改为:htmlfile,重启excel,解决问题。篇三:excel里做的超链接会自动消失?excel里做的超链接会自动消失?n次去你们“那里”看超链接做的怎样,偶用鼠标点你超链接的一刹那,弹出个:而后这位童鞋惊奇的告诉偶:“咦?.超链接怎么自动失效了,上次明明做好的。”我想告诉你,你上次真的做好了超链接了吗?是,链接上了,但你确认过了木有?确定你能点开它吗?步入正题。一、为何超链接会自动消失?其实超链接不是自动消
28、失了,是做好的超链接本身是存在问题的,这个问题的根源就在:乱码!没图说个jb,如图:图一:为正常超链接图二:为非正常超链接。分析:认真看图一和图二的地址处,你会发现有一些自动生成的乱码。1、地址处出现%20(正常超链接)2、地址处出现乱码:%20%5b20xx%5d%20(非正常超链接)挨个核实一遍,发现所有的正常超链接在地址处都显示“%20”所有的非正常超链接在地址处都显示“%20%5b20xx%5d%20”二、乱码是怎样产生的?乱码是由“20xx”产生的。为毛是“20xx“产生的?是哥发现的,哈哈研究发现“20xx”会产生乱码:%20%5b20xx%5d%20“20xx”会产生乱码:%20结论出来了,罪魁祸首是它-“”如图:因为“”是直接从键盘敲出来的符号。而六角括
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1