As I am working in SharePoint support, I come across so many issues on day 2 day basis and always try to share with all of you as soon as the issue gets resolved. Today, We have received one support ticket in which the user has created a list which consist of few items. When he selects list Actions--Export to spreadsheet--Excel opens up and Displays 'Security' dialog box by giving the option of 'ENABLE' and 'DISABLE'. When user selects the Enable button then 'Import Data' dialog comes up, and then user clicks OK. As soon as the OK action performs then suddenly it throws an error message: Excel Cannot Connect to SharePoint List
Resolution:
Generally we start our troubleshooting from the SharePoint side as what is wrong with my SharePoint site, Is there any problem in the SharePoint list, Does the Office which is installed on the machine is causing the problem ? Is there any site collection feature turned off? Is there any problem in the SP-Database? Problem with the IIS? so things are there by which we can think off but don't waste your time in doing all these things as I have done all these things and the resolution is quite simple which you can implement without any help.
1. Open the Internet Explorer
2. Tools
3. Internet Options
4. Advanced Settings
5. Scroll downwards and reach towards the section named as "Security"
6. CHECK FOR SERVER CERTIFICATE REVOCATION--which is by default checked
7. Unchecked it
8. Apply and Ok
9. Close all the internet explorers (IE) and open your SharePoint site in a new IE i.e. Browser/Explorer
10. You should be able to export the spreadsheet without any problems/issues.
Please let me know in case of any further queries/questions.
I would be more than HAPPY to help you as well as RESOLVES your issues, Thanks
Posts
Amol, Great to see this post.. i guess we have seen this issue in Baxter too?
ReplyDeleteyeah,we worked on this issue earlier but that was a different env. Please let me know in case of any further queries/questions... Thanks for your kind words :-)
ReplyDeleteAm still facing the same problem on MOSS 2007 with office 2007 with Forms based authentication.Every thing works fine as long as you are in Intranet But when you try to access from Extranet it fails with above exception.
ReplyDeleteIf you have any solution please let me know.
1) Did you checked the above mentioned resolution in extranet?
ReplyDelete2) is it happening on one specific machine or multiple machines ? Please check the machine configuration too
3)In addition to point2-Please check the explorer version also, try the same action Mozilla firefox too
Please check and let me know the results, Thank 4 your patience
To optimize Excel spreadsheets processing in sharepoint, we offer HarePoint Workflow Extensions software ( http://www.harepoint.com/Products/HarePointWorkflowExtensions/ ) - about 200 new workflow activities, including free ones.
ReplyDeleteHi Amol, I am trying to creating a link on one excel and pulling value from another excel and both are in sharepoint but after I put = then gone to the other file and select the cell it doesnt feed into this file please let me know how to tackle this.
ReplyDeletePlease correct me if i am wrong. As per the provided details, it seems that you are trying to fetch the values from another sharepoint list. yes-you can do this by means of 'lookup column' that will fetch the value from any list which exsist on that site.
ReplyDeleteIf you are doing anything else then please let me know in details, Thank you
Hi Amol, sorry for not get back to you for long since i was on holidays. i have different files on same share point also one summary file on same share point. so what i am doing is for summary just linking the individual file on the SP. so when I do this I am not able to link the worksheet to summary file. thanks in advance
ReplyDeleteHi Amol, also when I am opening the summary and individual files I am getting following error.
ReplyDelete'Unable to open https://central.com/company/summary.xls The internet site reports that the item you requested could not be found (HTTP/1.0404)' and a OK button after pressing so many ok button only the file opens up. And when I do this all the values remain same and didn't change with latest values from other files. The other issue is when I do the same from a different system this is working alright without any problem or any error. so not sure what is the problem on my machine alone. please help me. thanks babu
one thing is very clear that this is machine specific issue as it is working from different machine. Probable reasons would be IE problems, office problems or OS problems.
ReplyDelete1-If its an IE problem then try this:
-Open an new IE
-Internet options
-tools
-advanced tab
-RESET
-apply and Ok
after this:
-------------
-Open a new IE once again
-Tools
-Internet options
-security options
-sites tab
-add your site here (dont click apply and ok completely)
-click ok
-come back to the main window where u can see the custom tab
-go towards the bottom and make sure "automatic logon with current username and password is selected"
-apply and Ok
2-if its a office problem then try this:
Click the Microsoft Office Button, and then click Excel Options.
Click Resources.
Click Diagnose, click Continue, and then click Start Diagnostics.
If its an OS problem then you need to contact your local helpdesk to detect the problems
Hi Amol, Thanks for your kind reply. Its not a IE problem even when I saved it local I am getting the error while opening. I have tried the Diagnose on excel as per your reply but that still didnt fixed my issue. It's just telling same kind of error with some old link which we cant find it on that excel at all. Let me know if you can give me any other way to fix this issue.
ReplyDeleteIf the same file is working fine from other systems/machines then we need to go for office repair/might be the best option to uninstall & install the office again. If you do not have rights then please involve your local desktop support and check the results, Thank you
ReplyDeleteHi Amol, I am trying to sync the excel with the sharepoint list. In the excel sheet i have created a table excatly like the fields in the sharepoint list. In excel, design->Publish and allow sync, i gave the sharepoint server name, list name and description and clicked on publish button. But, asks for user-id and password but gives the error as "cannot connect to the server at this time. your table cannot be published". When i clicked on debug, it pointed to below VBA code.
ReplyDeleteretUrl = ActiveCell.ListObject.Publish(Array(ServerName.Value, ListName.Value, ListDescription.Value), False)
In the internet explorer, i am able to login to the share point server and add a new record in the list. But when i tried to publish from excel, it is showing error as described above.
Kiran,
ReplyDeleteI can suggest you multiple ways to workaround this problem so lets try one by one:
This problem occurs because of an issue between Windows SharePoint Services and Excel that prevents the Excel spreadsheet from being imported correctly to Windows SharePoint Services when you create a new list. This problem may occur if the Web site is configured to use Anonymous access.
Workaround no#1:
----------------------------
Try to install the below mentioned hotfix on your machine and then try the same process that you are doing presently. check the results and let me know.
http://msdn.microsoft.com/en-us/library/bb462636(office.11).aspx
http://support.microsoft.com/kb/951996
Workaround no#2:
-----------------------------
When we click on publish and sync option, in that list name, provide a new name so that new list will be created. please check this.
once new list will be created then you can move the list items by means of content and structure.
Workaround no#3:
-----------------------------
Datasheet view options is an great asset in SharePoint. Copy the data which is present in your excel sheet, open the list in datasheet view & paste. simple n easy.
Please check and let me know in case of any further queries, Thanks for your patience
Hi Amol,
ReplyDeleteI have an issue that I hope you can help me with.
I'm trying to sync Sharepoint with Excel in reference to the following document.
http://msdn.microsoft.com/en-us/library/office/bb462636(v=office.11).aspx
This has worked on my machine in the past (until my machine crashed and XP was re-installed in my machine) and it works on my colleague's machine. The issue I face is when I click the Publish and Allow Sync button, it creates the table in Sharepoint, then it deletes the table on Excel and it tries to create a linked table from Sharepoint. The third step is where it hangs on my machine. The status bar says "connecting database..." and then it just hangs there. This only happens on my machine though.
Any thoughts?
Thanks,
Jirain
based on the provided description- it seems that the problem is machine specific as it is working on your colleague machine too.
ReplyDeleteright now i can suspect that problem might be IE specific/office specific
which IE version and Office version you are using on your machine ?
Did the same versions present before the machine crashed?
can you please try same process in different IE i.e. Mozilla/chrome ?
keep me posted about the results, thanks for your patience
Hi Amol,
ReplyDeleteThanks for the response. Yes, I believe it's machine specific as well. I've I have using Version: 8.0.6001.18702 Update Versions:0
I have Office 2007 (+ Excel 2003) installed on my machine.
Yea, the same version was there before the crash. I did have Excel 2010 as well though. Although I just tested it on another machine that doesn't have Excel 2010 and it works.
I'm going to get my IT people to run windows update on my machine. Will keep you updated!
Thanks,
Jirain
Okay. Keep me posted and let me know in case of any queries so that we can discuss and proceed further, Thank you.
ReplyDeletevittal: sir i tried to do the above mentioned things but the error is same cannot connet to the server at this time your table cannot be published
ReplyDeleteplease help me sir
regards
vittal
Can you please explain as what excatly you are doing and brief problem description so that i can guide you?
ReplyDeleteI am asking these details as in your questions you have mentioned regarding TABLE. Thank you
i am trying to configure random quote webpart in sharepoint 2010, what i did is i have an excel sheet of quotes in excel 2007 trying to import to sharepoint list, but it was giving error cannot connect to the server at this time your ctable cannot be published.
Deleteregards
vittal
1. It seems that this is machine specific. Could you please try from other machine and check the results?
ReplyDelete2. Could you please provide the following information?
- IE Version used?
- Operating system
- Office version? Please check for any mismatch also
3. Also, could you please try to follow the same process from any other browser? Example: Mizilla Firefox/ Google chrome
helpful article .. thanks for sharing ..
ReplyDeleteThanks Prity :)
ReplyDelete