SharePoint 2010与2010 Microsoft Office Suite 64位兼容吗? [英] Is SharePoint 2010 compatible with 2010 microsoft office suit 64 Bit

问题描述

我公司的一位用户具有以下规格:

One of the user in my company has below mentioned specifications:

Office 2010 64位

Office 2010 64 bit

SharePoint 2010

SharePoint 2010

当他尝试访问已启用宏的excel文件时，出现错误消息无法打开工作簿，因为它包含了excel在浏览器中不支持的以下功能-数据验证"

When he is trying to access an excel file with macros enabled in it, it gives him error saying "The Workbook cannot be opened because it contains the following features not supported by excel in browser - data validation"

并且在下拉菜单中也缺少用Excel打开".

And in the dropdown also Open With Excel is missing.

注意:他能够打开普通的excel文件.

Note : He is able to open normal excel files.

可能是此问题的原因? Office 2010 64位与SharePoint 2010不兼容吗?

What could be the cause of the issue? Is office 2010 64 bit not compatible with SharePoint 2010.

谢谢您的回答！

推荐答案

你好Neha

Hello Neha

此问题与Excel的64位版本无关.看起来excel具有一个数据验证功能，该功能不支持启用浏览器的Excel Web应用程序文档.

This issue is not related to 64 bit version of Excel. Looks like the excel has a Data validation feature which is not supported with Browser enabled Excel web app documents. Data Validation is not supported in Excel Web App and will prevent you from opening the workbook in the browser.

2个选项

1.转到数据"->删除excel中的数据验证.数据验证->清除所有

2.强制文档库在客户端应用程序而不是Excel Web应用程序中打开文件.导航到库设置->高级设置->将在浏览器中打开文档"设置为打开" 在客户端应用程序中.

2. Force the document library to open the file in Client application rather than Excel web app. Navigate to Library Setting --> Advanced Setting --> Set 'Opening Documents in Browser' to Open in the Client Application.

我建议选择2因为您不必删除Excel Web App不支持的宏和功能，

这篇关于SharePoint 2010与2010 Microsoft Office Suite 64位兼容吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！