SharePoint 文档库:无法在 Excel 2003(带兼容包)中打开 xlsx
我的公司正在使用 WSS 3.0 来托管存储(主要是)Office 2007 格式文档的文档库。公司 PC 安装了 Office 2003(带有 2007 兼容包)或 Office 2007。
我们在使用 docx 时没有遇到任何问题,但当我们使用 SharePoint 文档编辑选项时,xlsx 文档无法正确打开。该文件在 Excel 中打开,但显示未格式化的混乱(接近记事本表示)。实际文件很好,下载 xlsx 文件(使用发送到 -> 下载选项)允许打开该文件。只有当我们使用 SharePoint 的“在 Microsoft Excel 中编辑”时,我们才会遇到问题。
我认为问题是 excel (2003) 尝试打开 xlsx 文件,就好像它是 xls 文件一样,并且无法表示压缩内容。以前有人见过这个问题吗?
编辑:我注意到,当使用资源管理器打开文档时,它实际上是通过 Microsoft open XML coverter 打开的。显然,SharePoint 没有使用它,是否有解决方案可以解决此问题?
更新:我做了更多的研究,正如下面的评论中所添加的,此问题会在我们网络上使用 Office 2003 和 SharePoint 中的 XLSX 文件的所有计算机上复制。我已经确认,使用 Excel 在资源管理器中打开 xlsx 文件(不使用转换器)会导致与从 SharePoint 打开这些文件时相同的问题。我想我需要一种方法来告诉 SharePoint/IE(无论实际处理办公室交互的是什么,URLMON/HLink?)XLSX 的正确文件关联不是 excel.exe。
My company is using WSS 3.0 to host a document library storing (mostly) Office 2007 format documents. Company PCs have either Office 2003 (with the 2007 compatibility pack) or Office 2007 installed.
We didn't have any problem getting docx to work, but xlsx documents don't open properly when we use the SharePoint document edit options. The file opens in excel, but displays unformatted mess (close to the notepad representation). The actual files are fine, downloading the xlsx file (using the send to -> download option) allows the file to be opened. It is only when we use SharePoints 'Edit in Microsoft Excel' that we get an issue.
I think that the issue is excel (2003) trying to open the xlsx file as if it were and xls file, and being unable to represent the zipped contents. Has anyone seen this issue before?
EDIT: I've noticed that when the document is opened with explorer, it actually opens through the Microsoft open XML coverter. Clearly, SharePoint isn't using it, is there a fix that works round this?
UPDATE: I have done a bit more research, as added in the comment below this issue replicates across all machines on our network which use office 2003 and XLSX files from SharePoint. I have confirmed that using excel to open xlsx files in explorer (without the converter) results in the same issue as when they are opened from SharePoint. I think i need a way to tell SharePoint/IE (whatever actually handles the office interaction, URLMON/HLink?) that the proper file assosciation for XLSX isn't excel.exe.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
你能在另一台电脑上测试这个吗?可能与导致该问题的注册表项和/或其他软件有关(因为您的 word 没有问题)。理想的测试场景是仅使用 Office 2003 和兼容包安装全新的操作系统。
Are you able to test this on another computer? Might be related to a registry entry and/or other software causing it (because you did not had problems with word). The ideal test scenario would be a brand new OS Install with only Office 2003 and the compatibility pack.