Excel cannot connect to the SharePoint list

Asked By raygets 0 points N/A Posted on - 08/04/2011

Hi to all readers in techyv,

I have an application issue here, that I have not been able to solved while working with in WSS2.0.

When I tried to use the export function and link to Excel or somewhat export to Excel spreadsheet and when it opened in Microsoft Excel I received an error message "Excel cannot connect to the SharePoint list."

Microsoft Office Excel

Excel cannot connect to the SharePoint list.

OK

Whenever I save and open the IQY file  it will create but it won't synchronize.

Please share some ideas on this issue that I posted.

All your ideas will be of great help to me.

Thanks a lot for reading my post.

• Status: Open
• Question Views: 3475
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Jasson 0 points N/A #98261

Excel cannot connect to the SharePoint list

 Hi Raygets,

        You can easily resolve this issue by following method.

• First you have to open the Internet Explorer.
• Then go to the Tools option.
• Then click on the Internet option and go to Advanced Settings.
• Scroll down the window and go to the Security option.
• You can see CheckforServerCertificateRevocation as checked mark and you need to uncheck it.
• And click on the Apply and then OK.
• Then you need to close all Internet Explorer pages and open your SharePoint site in new Internet Explorer or Browser.

Hopefully you would be able to connect Excel to the SharePoint.

About Jasson

Questions
0

Answers
4

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 08/06/2011
• Question Category: MS Excel