无法在Windows 10中从SharePoint导出到Excel 2016 [英] Cannot Export from SharePoint to Excel 2016 in Windows 10
问题描述
我正在尝试将SharePoint数据从Internet Explorer 11导出到MS Excel Professional 2016.
I am trying to export SharePoint data out of Internet Explorer 11 into MS Excel Professional 2016.
我点击导出到Excel".
I click on "Export to Excel."
然后提示我从网站打开或保存owssvr.igy.我点击打开".
I'm then prompted to open or save owssvr.igy from the website. I click on "Open."
我已移至Excel,并获得了潜在的安全隐患"单击启用"的提示.
I'm moved to Excel and get a "potential security concern" prompt at which I click on "Enable."
然后,我得到一个导入数据".提示,单击确定".
I then get an "Import Data" prompt at which I click on OK.
几秒钟后,我收到提示,提示此时无法连接到服务器."无法保存对数据的更改."
After a few seconds I get a prompt that says "Cannot connect to the server at this time. Changes to your data cannot be saved."
请帮助.
推荐答案
这是一个非常普遍的问题,其原因很多.请尝试以下步骤解决此问题:
1.取消选中检查服务器证书吊销".在IE>中工具> 高级"标签,然后重新启动IE浏览器.
2.请尝试在其他计算机上进行测试,检查是否出现问题.
3.如果您使用管理员帐户导出列表,会发生此问题吗?
4.请打开Excel 2016>单击数据"下的从Web获取外部数据",键入列表视图URL,测试是否可以在Excel中导入列表数据.
谢谢
王恩(Dean Wang)
这篇关于无法在Windows 10中从SharePoint导出到Excel 2016的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!