【#文档大全网# 导语】以下是®文档大全网的小编为您整理的《Excel打开时提示 你尝试打开的文件》,欢迎阅读!
电脑win7 32位旗舰版,Office2010。用铁二院的平差软件来处理数据,软件自动生成EXCEL文件,生成之后打开文件时提示“您尝试打开的文件xxx.xls的格式与文件扩展名指定的格式不一致。打开文件前请验证文件没有损坏且来源可信。是否立即打开该文件?”,卸载Office 2010后重装也不行。
这是什么原因呢?其实是因为警告消息是Excel 2010/2007中添加了一个用户通知函数。警告消息有助于防止由于文件的实际内容和文件扩展名可能不兼容而可能发生的意外的问题。
可以通过修改注册表的方法来解决这个问题:
1、打开注册表编辑器
方法:开始 -> 运行 -> 输入regedit -> 确定
2、找到注册表子项
HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0ExcelSecurity
3、在右侧空白处点击鼠标右键,选择“新建 -> DWORD值(D)”,输入“ExtensionHardening”点击确定。
4、用鼠标右键点击ExtensionHardening,然后单击“修改(M)”,在数值数据中填写“0”即可确定。
5、关闭注册表编辑器,再次打开xls文件看看是不是提示是不是不见了?
小知识:ExtensionHardening设置的值的数据设置:
* 0:不检查文件扩展名和文件类型并绕过该函数的警告消息。
* 1:检查文件扩展名和文件类型。如果它们不匹配会显示警告消息。
* 2:检查文件扩展名和文件类型。如果它们不匹配不要打开该文件。
分享给好友 ![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQAAAAEACAYAAABccqhmAAAAAXNSR0IArs4c6QAAAARzQklUCAgICHwIZIgAABo0SURBVHhe7Z3Rdtw4DEM3///R3XjSTjJji+aFYXmSYM/Zp1IiCYIQJSft23///ffn/f9v8d+fPzzUt7e3zdzoXqN9ls1de9F9qqK58lZ8VGtojjPyGMWr1Lxa84pNtnQH76qLMqHkWcJ0EUghAyWWkt8r+ogAXNQggtsIQBO0CMAaKOW0oyLnEvBmmR/MlJormCixudZEAJpIKmR4xdOZNmCuANsIjHCMADQbSjFTyOs6QSIAmQC+IhABUDr44JoIQB9Al/BlAvilE4DSbH161paUvMrpTH0ouVEfSh4//Zqh4E4xUXzQCeAV+2nJe/gG8IoBU9CXBOkaZ94RAKW1zlvjvJ9fySuKUJV3BOAJzQhAn15U4Po7n2MZAdh4x1kOyS24nY1Ay0mJpYzO1AfN4TZewR9CUvKg466zrjQ/BUPnmghABOCOwAzyUh8RAGe7b5B9IMiK11wBFNSaa2Y0DvXRDP3BjPqIACgo99dkAjBMAN8NRNqEfTp9WlIfCoZ0dHf6UPaiONL8qv2vjHcGF0a506nkdk2lbwBOcGnACkloQShx3Xd9Wlz6BlDlR+uhYOXKLwKwRkCpXwTAwGIqMoqIUvFz+lD2orDS/CIAEYAWx2hztjZ9MqI+lIaiDeL0oexFcaT5RQAiAC2O0eZsbRoBUGAq10QAjkOaK8AGhhGAPrEUAvV3ry0jAMeRVOr3a98AjsP9uYOLvM7PgEp+M8TS+WhJc6R1UupBMXReryIAYAKg5KnsKbGUJnD5UO7OV/q+sk4RgJMbiiqWQkSnwo7IqMS1tZdCOGeD0NNrhm+nD1onpR4UQyc/aT8t2OYKYGAYJVYmgDUCzkZwCXUEIBNASx4iAC2YSqMIwHEMMwGcLFiukyUTQCaAfwg4hS8CcKIAKKc8LW7lw7kXFSCFWFQsaX6v+iibNwAwyVBizWhCSlzlVV3xQRvEiRWtk9KcND/FB6DmzTRvACeeqMvWlFhOUlMyzPCdCYBWZdteqdXWThGACMAdAYVU9FSLAEQAjiBAD9TblLMcxFtOlc1o8NTHjCZUxnN6p1Z8OMWExkvrpIznND/FB+VnJoBMAJkAhKua0pwRACpPa3tFqDMBNHGfMX3kCtAsxo6ZUqu8ATwh4AJRKekrfkpR8nCucZ2Qzrq6YlImhmqNiz8KVtS3kyP0aie9AVwZsDLi0HiVolMfir2r2Zz5uWKKACiM6K+p6oSvAH23uiVVUScRnQ2iI7Be6crRmZ8rpgiAkymMOxGAF7r6KGMtpU4EoN8gClb08KL1U+wzAQDUlKKD7WVT12nrzM8VUyYAmRathRGAFkwfRs4GAW53TV3N5szPFVMEYLf8hwwkATjk8aTFyiMgXUPtK9Gg4+DVP3hCc6f2vxmrk1ri8LbDN4DDO5+wQQh3/P4akVljOINXJ7SDZcsIwBOMM8gQH79PyCzdesImEYAIwB0BKkzUPleAEzr44JYRgAhABODP5u/DWf8+gIN9etryCEAEIALwmwXgfYzblr/TNMe/sfNzlHOs9WfavzvP8K34oHSjX1KWmCgfvlvNFdxHa94iAI/QfDcyULI7yaPsFQFQUDtvTQTgxCvAeWX73DkCcHwq+m6i7+RVBCAC4OTT7l6ZAHYhmmoQAYgATCVcBGAq3LvOIgARgF2SOA0iAE40j+91ugDMuKNWpKKvyNReKYHTh3Ov4Uvx2/K1uP+fsx59r/vvIvSuT8VqiYDyXfFB61TW4+yvABQQpeBOwl3ZUAoZrox3VCtnPRQ+UEyofRUT5btS8whAc2yvFHnGaeAs1Iy9qI8IwBqBCMATJhQQRfGdJ47zNKANpZwGV8YbAYgA7PZrBKBPkgjALp1aBlQUqX2uAK0yfBhFACIAXxFwNptrwnLGRPmuiL4r71t/5hHwEU4nGZyFmrEX9ZErQF/cFazAOVsettJXANoI1L6aDmaoIgVXicl5GlB8qf2ssZbGRTFc8lBqRfngEkvFL33ALms7mgBchXI+0ClgKQTa8qOQivp2YkXrFwFQ2HV8AlC8RgAAarQJnaMa9R0B8DSUItaAUqUprbniNwIAUHMVRCEV9R0BiAB0qB0B6KD014Y2YSaA4004Q8gqCihiDSiVCWALAeXOqayhhYoAPCKmNAfFMAJAWcrsp0wArldOJ+GUvb5THlWjOYvumnKoMDCa19YKF+iB8xvqgX8OgBZ9RqEUYr1iHr+BcEqtttbM4NVvqEcEoMnIEO7420AT6pZZ6uGpRwSgRTfth0sycjbBFcwiABEAgTafS3IFWMNHm4pieKhgT4tprMvyCPKGaIx+EvA7PZ4pxKLkDeE8J45Sq7wB9FCjnL6J4vv/ln8YRHmlpk1FFbxS/RGkNKaqNEq8VHgV3Ht02rdSfNM1Sj2URtjP9piFMw+KYcnRCMAjPEqhXE3rFJMZTaAQka5R6jEjdyoHzjwohhEAUC2lUBGARwScn8+UekQA+oTPFcDwuBQBiADstZxTyDIBgKalp4FSqAhABCACYPwnlp0NFQHYo6b+58pJRNcogkxrriPQX+nMg2JYvgGMPgO6QKwSd/moEqRgKYWigjWyV3zTLw0K5jQu5Q2g30oflkoeFHfFB8WK5u18KL7hGAF4hNRZQEogxXcE4HgL0UNCOXCOR7m/A+VCBGADU6UJMwEcfwPYp3ffB90rArCBGD296HjlHuOof0UtKbEohor40DxoTEvONK5cAShTPPaUC5kAMgG0mBcBaMF0M6JY9Xfet4wAgIZWwNovwbExVSEPzSMTwLqKuQLkCnBHQGnCvAH0hc+FryJkrmtidRC48qOHTXWlLr/ELVMLcfaKCb5qQQiu6psIrYfSONQHzftqezpFVfEq+LryVyYZ/KPAV5JBAffKeGlhZ+Q3wwfN+2r7CACowJUN9dPJOyO/GT4AnV7CNAIAyhABAGBB0xnNOcMHTPty8wgAKEEEAIAFTWc05wwfMO3LzSMAoAQRAAAWNJ3RnDN8wLQvN//VAuD6XQBFGBQyUrYoL6NbPspPKW/LW+r6P5fvZWe6F7WvfIwwv7JxZtRD8UH5qdjTXqv6zPbLQDSoJfEIQL/8tKGpfQSgL+CzuDtiB+21CMAGklR8lNNAaUJadHoKV3m7iEX3URpqRj0UH31J1y0pvhGACMAdgQjAmgxURBXB0tudTSZbfiIAEYAIgPEdJQIAHrwq5aNjuKKirjFcGQddvvMIyE5BeqJT+18hALTZnCA67zg0D3oHVwSO5qfk4BRXZ7yUJzPyUHy4MHH6ptjehGz0GZCSTnIOP5+NYlJApPkpBVcwoXHNwETJncblnJaoiCv8cWHi9K3wLQLQ7Dil4EpBmuHsminEoo2zGwR4e4kA9NGkWJXX10wAPeAjAD2c9qyoKM4QMsWHwoctbJy+Kba5Auyx9cufKwVXCgJCKk0VYmUC6KOv8CEC8ISAq0GcZHc2gSu/Pi0/LZ2YuMh+O3Hgu8+MPBQfLkycvim2t3q8/7/5NwK5EqzIqyRPm8F5X3I9bNF9qpxfMb+qri5eKdxx+aYcVIRvlo8IwBPSCkkU5X3FcZAKExWfZX8F37OxUpqNrnFxRDlQy0fATACPkCoEdRXXeaq5YlJOr0wA6zZ11sMl1LkCbCAZAThO3gjAcQzphKEIdQQgAtDiGT29IgARgEPEai1uGtF7aiaA4+SNABzHsEnvBzMq1JkAMgG0eEaJFQH4wQJAH6rKF0j4TZg+flTspic9zVvx7WwcZ7wtlWga0YlstK3CK7rX1Ri6sKpKgz8DUlCUQs1ozhk+nIS7Mt5mb7fMXKRWeOWsRyvZg0YurCIAhlGfCl8mgG0EXKSOABxUl7/LMwE0cYwANIHaMYsA9HF0YZUJIBNAn3UnW7pInQnAU6hMAE0cMwE0gcoE4AHqfReXWJYTwLsT9M+DOxuBIgVDpduX9s68lcK6cr/6S4OS+1ZhFDycnzNd5Lo6D/w3AjkbgYKogEV9jOydeStN4Mo9ArCusFIPF6+UujqFLALQrGQEYA2Ugomr2a5unCZtds2uziMCsFuiDwOF7KOtlSZQiLLlPxNAJoCvCEQAIgB3BKjIKKKoiF/eAB4RyBWg2bROM4XsmQDOO22pWFVTnEuUFL5dncfwM6CSjGuNAorLt/IIeGW8VJiU7+fO/OjpNaMerpgqDl7po4zr/Q/RZ8CzG23Z30k4V7zOu7MrJuVtIgKwRv/K5nRynR4GN/5EAHrtGAHo4bRn5Wo2Zz1cMWUC2Kt+88+dqth0uWvmJNyuM2BAVT8TQCaArwhkAmg2WwSgCdSOmeu0ddbDFVMmAA9H8gYAcMwEsAaLTpARAEC4kanyKYWuofZKWpQ8ig8n4V5RAJTTmWKi+BjVimJY1Zxy1Mk3iqH1EZAmvjina6i90pzOglDCKb4peWe8ASjNScmr+KD1cPKH5qf4VnzY3gCU5qRrqL0CotKE1I9SKBd5IwD9R0BaV+ehpvhWeBUBeEI6AnDendrZIJkA+kJWiv4yiStq87xGOZ3pGmqv5BUBiAAovPm3hnLUybdMAEcq93etsyB0bFd85w3gXMGilIoAPCGmjGpUyWgTVEVVmpCShOZX7U9zzxtAf3SmdXVecRTfCq9sbwBKwK5mU0RGide1RimUa5pwYkXFp2oQV36KWLp4uPhWMBnF7JomqpgiAK6uBvtEAPpgXYlVP8pPywgAQM2lvM5TDYQvm15JaidWCtlpza/ESimwgkkmAAXpL2ucpD4YSmv5laR2YqWQPQLQosjNKFeAJlZOUjddHjKLAPThuxKrfpS5AihY2X7pJwKwhp+eHs4HuooMmQD6rUJrSO1vj5bLpNEPaWypOKd+KXluCcJ/gnzGWEvzVvJ4VR+juCjur8oFiruSB/Ux5StABICWhdlTIWO7f1jP8BEBeEQgAgCYqoBFSU1PImV0BinfTWker+ojAhABULh5WxMBWEOnYEKb0OmD+h7ZKzFREVUOA0puJQ/qI1eADcScV5Yri+j0TRuEErGyp82m5E3zozEpeCh5UD8RgAhAizO0QVqbNo1osymNQ/OjMTVTfTBT8qB+SgF4DwB9BaAg0mAVe6VQMG0lLOuj2gzcr/QxY9SXiggXfbvJMgIAKwzMnQ3l3Ivew51iScVa8U19gJLumkYAdiHyGygFV4hFI3c2rXOvCACtZN8+AtDHymYZAfBAeaXI5AqwRmDKIZUrgKd5tnZxNpRzr0wA59U8E8B52A53zgTgAf1KkckEcNEE8O4WfQVwjiVK424RpYppBqk97Vf/bTLOk8UVr3MfyiuFO04fdC8Fqxncxb8M5ExcKWIE4BEBF4YKQZ1rKK+UvJ0+6F4KVhGAJmqZAJpAvbAZbagIgKeYmQA8OFp2qUidK8DxyccpMnQvhSCZAJqoZQJoAvXCZrShMgF4ipkJwIOjZZdMAH0YIwB9rCrLCIAHR8suEYA+jBGAPlalAIx+EIjeP6j9EpSyxpP2eBclJoWMNI/vNCLTWEuCDv5Kt2qNy/+Muip5UI5WebxFAHqPS8o7A21yhQyjNQp5aeNQIip4zMjDiaGS42gNffil9rdDOAIQAfiHQASgxwVnkyuiT4U3EwCoGAW3usoAt7umruZUCEdPSBprrgDbCNATndpnAtjAPQKwq0V3AwWr/u4flrkCrBGjuGcCAKyj4KokBSHdTOmpOqNxFKxo3jPyoBMOzUG1pyc6tb9xd+HWVoDKZmqi3XW0CZTmVPJW4trKWfkM2MXun53SUNTH1Q+mo3hpnWbUg2Kr2JcTQATgEdIIgEKxHoaKIB+P5nOHCMDGdSIC0CPvjNPgah+uZssE4ELSs08mAIBjJgAA1sA0AnAcQ+cOEQCAZgQAgBUBOA7WhB0iAADkCAAAKwJwHKwJO1g/A7peWKsHIaUJz8aRPiAp+Sk5OD/Fub4QOK8AM3BX8nZxVMGKYhIBUDrraQ0FPQKwDTptthm405iWzCIAFzSIUihD79+2mEFEJdZMAGvUKCYKryIAEYDdfqVE3N1ww8DpQ2mErZiVsfa7XS0jABGA3X51NufImdNHBGC3pHeDCEAEYJctzuaMAOzCfTeguCvC92MEYLne9qHlljPuzs6foPtuZKAVUepBfVT2ruaccc1wcsGJofMwwH8nIE1EIZyLJMrjnbPodC8nqZ13alrzCIATsf5etG+WnSMAT/jSpq1Ehu4VAViTXSI1/HsEXeO8cuD023vfUsIqV4BHYGnTRgD2ifnVgpKU2t9OtQjAQ1HKgyUCEAFgLXzMmjY0tY8ArOsTAQCcpadHJgAAbnE60zHceV2ivquMlTcvhuDYWhLLTACZAFwE7OxDSUrtMwFcNAFcqaLOz4AdEj/bUJJ+tyljxqnmxJDGO6Mer9oftq8Ar5ogJUMEgJ0gCl5bayIAfSQppyuBiwD0cR9aOsk7cuISWOXuTAmnQOrEkMabCUCp2NMaF0GrR7VRmLkC9AsYAVhjFQHo82doGQHoj84zCEcnierxjJ6oCp0yAfRRo/XIFaCPrWTpJC9tXCommQAyAXxFYPiPg0qdABc5yQtd43+aXLlm0PyqHFwTliIAFFvF3nmq0b2UeK8UfRpvOQG8g3XqbwNWwdIGcYbqLKCrOSMAfWorgtzffd/SyR869e1H92gRAdhAzFnACAClZP+9ZLRzBKCPeQQgAnBHIFeAfuMo06vzMHBNvBGACEAEwNP3912cE2SuAM3iuBRxcecsoFP1KRmc7yh0r2bZWma0trkCtGC9GVkngBmN00/tw/JK4i7+neSluc+wdwocxUrJj3JUeWc4W6irvGk9ymsf/QpAwZ2h1BEApU36ayjhFPL2o9m3pByNAOxjesrdx3UaRABAAQXTCEAfNCdWrikjE0C/fpIlFbKrBYsm6SQ1xYrGWl0JqW+lTk6sIgDN6iuFam7dMptBrFYgJxk5SU2xUlLKFeARtUwACovAGkrqqwULpHYzjQD0EXNiNWUCWOrbT29sSZugGtVciVfkdeSs7uE6oSr/ig+6RhEyyhMa0yxeqbUn66ZgFQEgJfHYKqSmnhUfdE0EgFaF2UcAnvBSxisKIiuRZk0bTfGi+KBrIgBKZfprKHdp/W7TUiaAfkFclkqhqG/FB10TAaBVYfYRgEwAjDFfrGkzV3dnZfKi7zgje2ceNCZF4OSCbSyMAEQAZD45GycCIJfh0MIIQARAJlAEoA+dU+D6XvctpwgA/V2A/bDnWyi/b6A0CM3M6cM1jpY/FDL4RzVpg1DiVtcPivlir/jf8qPwisar+KC8qnxc+ncCUrDoPbEiAwVRidXpIwLQr0AE4BGrCMAGd5zNSYVJIWgEIALwDwHK3QhABOCOQK4AfSFRxvP+7h+Wio8IwBPKM0Ckha2KmwlgjaZrwskbAMM2bwBPeCnNmSvAIwIKhhGANYtcj6/lFWB5NFVOtyvWUECufgSkwlBhSpuKjol74yipt3LNIPurtgp/Rr7oXtTeyd0IwEVvABEANo6qjd1dpzRhBKCL7gQ7pYB0DT1plbSVcZfGlQng+EitTGQU9xnvV5kAMgHcEZgxns/woQgvPQwiAArKJ65RCkjX0JNWSTcTgILa8TWUCxGA45hbd1AKSNdEAI6XLBOA5/rh4q50BZjRCPSRjAJSvaS6fFftQu+DSutRH8qdU4nLtYbmt/ilE9YMXlG+OblbcvT9Dzc/A0YAHmFT8FDISxuH+ogAnHs6u+oXAdhAcoZS04bKBEApz+yVemQC6GM8/CvBlBOv77a2pEV3nmrUdwTAVfXtfZR6RAD6NYkAPGGlEI7e75ziSuN1imWfZrolzS9vAAzrCEAE4I6AU5gYDcfWEYA+knTyuYklfQRUnIxSoHd6at+H7tNSaQJKUmpfnWpKvK6JRcnjbN/V45mTuwq36BpaW6UeEYCnqlDQleaUCgX/ui5Ktll5RAD6laFclHiVCeCxIBT0WY2jFLdPtQ9L6oPaV/HQvZS3jEwA6wpkAsgEcEfA1YRXimiuAOsmL38yMxNAJoB/CEQA6Mx0rj0VUlq/29QXAYgARADObWR19whAczx33u0o6LPuzoq6U+JRH9Q+bwCsIpSLSj1+xAQwi1isfL5/oEIRGRrrLB+juKiI0+ZQ8HCuUZqT+qcY/pgrQASAUmXbfgZJIwDHr5wuDCMAG0gqKjoqiPOUmtGcM3y4yOvE1iOf9S4zsFW4myvAU90UECMAx1uI4h4BWGNOMcwEkAngAYEZp1QmgFwB7gjQn+1XVJ+SWlHRTACZAPYQoDzc22/rzxXu/vgrwIwThxZXKRQVP8UHJR2Nie5/G1EHvwNR7UUPFkXAac2V3F3crXxHAJqVKX+cEv6ijpPUM0iiNEgT1l0zJ1Z0L2fNdxMFBjSPCIDhru8kg1JAetoqPgAHb6Y0Jrp/JoBtxJy1zQTQZGUEYA1UBOD7YDKcFBch3/pD1z3KeVdzEo6qaATg+5DdxV1nzZvnTMuMcjdXgFwBWsSiRk5Bdr5lRAD6lcRXgP7WuuWMF1anD+detBFmNCGNSa/8NSsVwaC4Kxyha5TJIALwxDla2OqhStmLNpvTB20/hXDUxwz7CMAGyq9ILGdMVF3LexT8DKiQ2hmv4n9rTQSgj6RSP7pGqUcmgEwAfRY/WSqEk52duDATQCaAOwLKlEGVWuHyDB80rghAHzGlfnSNUo9MAJkA+izOBCAfFLSZlbclqwDIrDhx4YzTWSnUjIc7Ghe1dxJOqZOTNkojUP/KtYH6GNlT3+XPM7w72fxBIFewzn0UYtFGoPazHgdpXNQ+AsCYSpuQ7V5bU98RAPDGoTROJoBHBBShdjZIJoB+PYZvAM6CuPZSiEUbmtpnAlgjoNTJxZFqknH6oKfwlb4zAWQCaD1eUfGj9s4mUITX6T8C4ESzuZdyslCSUnuFiK+aB82d2jfLfNgsV4BcAe4IUJJS+whArgBfEXhF8akOnP8BJYA13Iy/cWMAAAAASUVORK5CYII=)
微信扫码分享
相关推荐
最新更新
热门阅读