从外部列表导出到Excel

本文介绍了从外部列表导出到Excel的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

让我给您所有简短的信息，

Let me give you all brief info,

我正在使用BCS Services将数据从Sql Server表中拉到sharePoint列表，因此一旦创建了列表，并且如果我尝试导出以使数据更胜一筹，当我远程登录到服务器时我就可以做到但是当我试图提取数据时 从另一台具有相同登录ID和密码的计算机上，我收到此错误"Excel无法连接到Sharepoint列表".甚至以为我仅使用管理员帐户登录.

I am pulling data from Sql Server table to sharePoint list using BCS Services, so once the list is been created and if i try to export to excel the data i am able to do it when i am remotely loged in to the server but when i am trying to pulling the data from another machine with same login ID and Password i am getting this Error "Excel cannot connect to Sharepoint list " even thought i am login with admin account only.

您能帮我解决问题吗?

推荐答案

您好，Kasalalit，

Hi Kasalalit,

您的客户端计算机中的Office版本是什么(我的意思是桌面客户端)?

What is the version of Office in your client machine (I mean the Desktop Client)?

这取决于您的Office版本或浏览器.确保您仅使用IE 32位版本，并在兼容模式下运行它.另外，请确保您在互联网选项中具有相同的设置

It depends on your Office version or your browser. Make sure you're only using IE 32-bit version and run it in compatibility mode. Also make sure you have the same settings in your internet options

social.msdn.microsoft/Forums/sharepoint/zh-CN/b5793a38-f74d-4e0f-bac0-bb41be959a38/sharepoint-2013-external- list-export-to-excel-2010?forum = sharepointadmin