“在Excel中打开"在SharePoint 2013中的Excel Online中变灰 [英] "Open in Excel" Greyed Out in Excel Online in SharePoint 2013

问题描述

我们已经使用SP2013环境中配置的Office Web应用程序执行了从SP2010到SP2013的迁移.我们有一个相当大的数字.启用了保护的Excel工作表.因此，按照MS规定的规则，这些规则不会公开 在Excel Online的浏览器中.因此，发生预期的错误，指出:

We have performed migration from SP2010 to SP2013 with Office web apps configured in the SP2013 environment. We have a considerable no. of Excel sheets that have protection enabled. So, as per the rules stated by MS, these are not expected to get opened in the browser in Excel Online. Hence, an expected error occurs stating:

"我们很抱歉.我们无法在浏览器中打开工作簿，因为它使用了以下不受支持的功能:
-工作表保护

"We're sorry. We can't open the workbook in the browser because it uses these unsupported features:
- Sheet Protection

您要改为在Excel中打开文件吗?

Do you want to open the file in Excel instead?

了解更多信息

在Excel中打开   取消

Open in Excel     Cancel

"

但是，按钮在Excel中打开"被禁用(灰色).因此，我们无法在客户端应用程序中打开它们.我们可以找到类似的帖子，但找不到合适的解决方案.有人可以建议解决方案吗?

However, the button "Open in Excel" is disabled (greyed out). So, we are not able to open them in the client application. We could find similar posts but could not find a proper resolution. Can anyone suggest a resolution?

我们正在使用2017年11月的CU修补程序，并正在使用IE 11来查看网站.

We are using the November 2017 CU patch and are using IE 11 for viewing the sites.

推荐答案

您好，Anmol Bhatia(Mercer )，

Hi Anmol Bhatia (Mercer),

您是否在服务器中安装了excel?

Did you install excel in the server?

有一个解决方法.您可以下载excel文件，然后在excel客户端应用程序中打开该文件.

And there is a workaround. You could download the excel file and open the file in excel client application.

您可以考虑删除纯粹的保护措施，以在excel在线中打开excel文件.

And you could consider removing sheer protection to open the excel file in excel online.

更多参考:

编辑包含Excel Online不支持的功能的工作簿.

Edit a workbook that contains features unsupported by Excel Online.

最诚挚的问候，

萨拉范

这篇关于“在Excel中打开"在SharePoint 2013中的Excel Online中变灰的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！