Monday, September 2, 2013

Cannot connect to server at this time. Your list cannot be published

1.Cannot connect to server at this time. Your list cannot be published
2.Excel can't import the data from Sharepoint List
3.Cannot connect to server at this time. Your list cannot be published

These are all the error we faced when we try to import data form Sharepoint to Excel sheet.
I spent many hours to figure out this issue , I found list of solution. I decide to list all the solution
because one of the solution should work in your scenario. A clue to solve these type of errors is "security" settings.

Here is solution links

Solution 1: // Check Sharepoint list premisison
http://social.technet.microsoft.com/Forums/sharepoint/en-US/8d8704e9-b14f-477a-945c-fa6740cbe065/cant-export-list-to-excel-you-do-not-have-adequate-permissions

Solution 2: // Check your IE certificate security Setting
Open your Internet Explorer.

1. Click on Tools, then Internet Options
2. Go to Advaced tab
3. Scroll down to security and then uncheck the "Check for server certification revocation"
4. Restart your browser and then try again to import the list again. This should work.

Solution 3:
http://support.microsoft.com/kb/838703
// but not sure it works or not some time we don't have permission to create anything as this solution suggest to do.

Solution 4:
This is the solution I found on my own becasue after checking the security settings of SharePoint List(Permission) for the current user (who try to import the list data), then IE certificate security
settings. I conclude that Excel has some permission issue with Sharepoint List because I was access the List through "Https" Protocol.
I open the excel sheet in the Main menu Data-->From Web---> connect to the SharePoint site it ask the credentials after providing the credentials of user then try to import
the List data to Excel. Logic here is Excel saves this Credentials which helps to import the actual list data.
Follow these steps:

1.If your list is not already open, click its name on the Quick Launch. If the name of your list doesn't appear, click View All Site Content, and then click the name of your list.
2.On the Actions menu Actions menu, click Export to Spreadsheet.
3.If you are prompted to confirm the operation, click OK.
4.Windows SharePoint Services 2.0
5.If your list is not already open, click Documents and Lists, and then click the name of your list.
6.On the page that displays the list, under Actions, click Export to spreadsheet.
7.In the File Download dialog box, click Open.
8.If you are prompted whether to enable data connections on your computer, click Enable if you believe the connection to the data on the SharePoint site is safe to enable.
9.Do one of the following:
10.If no workbook is open, Excel creates a new blank workbook and inserts the data as a table on a new worksheet.
11.If a workbook is open, do the following in the Import Data dialog box that appears:
12.Under Select how you want to view this data in your workbook, click Table, PivotTable Report, or PivotChart and PivotTable Report.
13.Under Where do you want to put the data, click Existing worksheet, New worksheet, or New workbook.
14.If you click Existing worksheet, click the cell where you want to place the upper-left corner of the list.

Click OK.

14 comments:

Unknown said...

Hi, your article gave me a clue for my issue - I could not extract a list from Sharepoint to Excel, I was getting the same error "Cannot connect to server..." . I followed your steps (option 4) and logged in to the page from within Excel. I got some rubbish, but when I went back to IE and tried to extract to Excel, it finally worked :-)

Thanks!!!

Unknown said...

Thank you very much Nasich.
It was your only post that unlocked me to continue with my project.
I really appreciate your work !!

bitultorah said...

Thank you for your work.
I tried a bunch of things, including what you mentioned, but there was one more step that I needed to take. I added my site to the security (I think that was #2) and unchecked the "require verification". However, it still didn't work. I then went and for "trusted sites" I lowered the security to low, and it uploaded.

Thank you,
Shlomo

Karthika Shree said...

Great post! I am see the programming coding and step by step execute the outputs.I am gather this coding more information. It's helpful for me my friend. Also great blog here with all of the valuable information you have.
Sharepoint Training in Chennai

pgdleo said...

Thank you! Option 4 works for me.

Anonymous said...

Great Article… I love to read your articles because your writing style is too good.Oracle Weblogic Server Training

Unknown said...

Thanks all, your feedback are valuable to me.

seo said...

Really It's A Great Pleasure reading your Article,learned a lot of new things,we have to keep on updating it,Walk in Clinic in Chicago.By getting them into one place.Really thanks for posting.Very Thankful for the Informative Post.Really Thanks For Posting.

Unknown said...

Good article. It is very useful for me to learn and understand easily USMLE Thanks for posting.

24Layouts said...

Very Much Impressed With the Blog and Also For Delivering the content in the most easiest way
and we offer the best Vizag Real Estate Ventures .Really Thanks For Sharing Such an Useful Information.

Unknown said...

thanks for the informative...keep on sharing such an informative stuff..

Vijay Devarakonda Height

mohamed elmahdi said...

for me was the domaine name in login, i must connect using "DOMAINE\username".

Mrbk30 said...

Very Informative blog thank you for sharing. Keep sharing.

Best software training institute in Chennai. Make your career development the best by learning software courses.

devops training in chennai
uipath course in chennai
rpa training in chennai
cloud computing training in chennai
PHP Training in Chennai
blue prism training institute in chennai
microsoft azure training in chennai

Block said...

It’s always so sweet and also full of a lot of fun for me personally and
my office colleagues to search your blog a minimum of thrice in a
week to see the new guidance you have got.
best big data training in Chennai
best software testing training institute in Chennai
javascript course in Chennai