SharePoint2010中无法使用Datasheet View功能的解决方案
今天收到User反馈,在Site Collection list中无法使用Datasheet View编辑数据,在点击Datasheet view时弹出下面错误提示"The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Microsoft SharePoint Foundation is not installed, your browser does not support ActiveX controls, a component is not properly for 32-bit or 64-bit support, or support for ActiveX controls is disabled."
经过排查主要是因为在客户机器上Office安装的版本Office2013 64-bit,此版本不支持datasheetview功能使用,需要安装一个组件“2007 Office System Driver: DataConnectivity Components”解决。
具体步骤如下:
- 到微软官网网站下载组件“2007 Office System Driver: Data Connectivity Components”,地址:https://www.microsoft.com/en-us/download/details.aspx?id=23734
- 下载copy到有问题的机器上并安装。安装过程没有特殊设置,直接下一步到最后完成即可
- 运行完成后重启机器,打开站点验证,Datasheet view可以正常显示使用,问题解决。
感谢阅读。