locked
Cannot connect to the server at this time. Changes to your data cannot be saved.”

    Question

  • hi All,

           i 'm getting the error "Cannot connect to the server this time,Changes to the data cannot be saved" while trying to perform an 'EXPORT TO EXCEL' in a sharepoint list.

         i have tried with the following action already to resolve the issue, but failed.

                       1. check the AAM(altenate access mapping).
                       2. Since its happening for only 'https://' sites ( SSL + HTTP) i have tried resetting on IIS and adding the sites   to loca lintranet and trusted site.
                        3. Since this is happenign only with Vista machine, i tried stopping the 'Web Client ' service and peform the action

                the error message above displayed on the 'iQY' file generated while peforming the export to excel action

                  Machine config : Vista SP1 + office 2007 + MOSS 2007.

    Please   Help............
    Monday, June 01, 2009 11:31 AM

Answers

  • Hi,

           Brad and Yagyashree , thanks for all the support and help,

           The issue resolved on a temporary basis: :) 

           Here's how it can be done :  Open an excel file on the computer.

                                                     Copy some contents from the sharepoint site to the excel file

                                                     It will ask for password prompt, provide the sharepoint identity.

                                                     Go to the sharepoint list , perform export to excel,  it works like charm.


      Once again - Thanks for all the help from you buddies, it was exactly the windows- sharepoint identity confilict  as i suspected. ( Rare Conspirasy : )  

    Regards,
    Aj.

     

    • Marked as answer by Ajith George Wednesday, June 10, 2009 1:27 PM
    Wednesday, June 10, 2009 1:26 PM

All replies

  • Hi.

    What sits between your MOSS Server running over SSL and your workstation? Are you proxying through ISA?

    What are the symptoms - are you getting prompted to log in, or does it just fail immediately? Is it only happening on your Vista? or is it other people's vista too?

    I think the most likely culprit is in your Excel security settings - go through them and see if there's a setting in there that the IT security team have locked down on you...

    The other thing it may be is the recent update that seems to be causing some authentication issues...  - I have some info here... http://sharepointblog.spaces.live.com/blog/cns!74C8FB1191265567!511.entry
    Brad Saide
    bsaide[replace with @]exemail.com.au http://sharepointblogs.spaces.live.com
    Monday, June 01, 2009 1:23 PM
  • Hi Brad,

              Thanks for the reply. This problem has been driving me crazy for the last few days which started after my macinhe was re conifgure to use vista OS. 

              i dont think that thers something between server and SSL since itz works fine on XP OS and for http:// sites and for  some https :// sites too......

     i have not much idea regarding the excel security settings.

           when ever i say export to excel i getz the excel open/save dialog box and when  i say open it gives the message.

           i have tried with most of the IE settings.

     Do you think that the excel service may give a problem here.

     is it something related to SSO...........

    Please advise.
    Monday, June 01, 2009 2:05 PM
  • Sorry it's got nothing to do with Excel Services - this is a straight Export to Excel from the menu.

    So...

    Is it just your version of Vista or are there others that have the same problem?
    Does your Vista and a Working XP run the same version of Office / Excel 2007?
    Have you checked the security settings in the Excel that is installed on the Vista laptop?
    Is this an internal site or external? Do you access it using www.sitehere.com? or just http://sitehere?
    Brad Saide
    bsaide[replace with @]exemail.com.au
    http://sharepointblogs.spaces.live.com
    Monday, June 01, 2009 2:16 PM
  • Hi,

            Thanks for the reply once again,

             I think others who are using the vista are having the issue but not sure whether its the same.

            Yes the vista and xp runs the same office versions,

              i m not sure about the security settings of excel on the machine. can you please provide with a check list on this.

            The site is an intranet site which is accessed as https:// sitehere.com

             What do you think are the possible reasons of this issue.

              is it something related to persistant cookies and web client service.

     Any hopes ??

    Regards,

    Aj.

       

     

     

     

    Monday, June 01, 2009 2:22 PM
  • Hi All,

            Can this issue related to the server configuration or AAM.

           Is there any way to perform the export to excel process in sharepoint.

         Please advise.

    Regards,
    Aj.
    Monday, June 01, 2009 4:46 PM
  • 1. Add an 'internal URL' AAM of "http://sharepoint2:81" for the SharePoint2 web
    application.

    Or

    2. Change both sites in IIS to listen on port 80 with host headers. Change the ISA
    publishing rule for SharePoint2 so that it is not redirecting to port 81.
    Visit: http://yagyashree.wordpress.com MCP & MCTS [WSS 3.0/MOSS]
    Tuesday, June 02, 2009 12:37 AM
  • Hi thanks for the reply,

            but i dont think this will work since the server being at a multiple farm configuration its not possilbe to make th eport listen t port 80 only which will affect the NLB.

             Hi Is there any chances that the issue is related to security certificates which is used for the site. is there any more settings related to security certificates that makes the trusted site security certificates to get added with  the  sites.


    ITz CRAZY...........Do any one have a soln...................???????????????

    Regards,
    Aj
    Tuesday, June 02, 2009 9:55 AM
  • Hi Ajith.

    We're trying to help you, but you need to help yourself as well.

    I think others who are using the vista are having the issue but not sure whether its the same. - Find out and let us know - this would be a first step.

    Yes the vista and xp runs the same office versions, - Good - This eliminates Service pack or patch issues on the office client

    I m not sure about the security settings of excel on the machine. can you please provide with a check list on this. - Use google to search where to find the security settings in Excel, then have a look at each and reduce the security incrementally to see if the issue suddenly goes away

    The site is an intranet site which is accessed as https:// sitehere.com - so... it may have something to do with AAM's and Kerberos perhaps? Try Yagyashree's suggestions instead of dismissing them...

    More questions...

    What appears in the error log when the error occurs? Check the Application log, the security log (to see if there's an authentication issue) and the SharePoint logs.

    What browser version and service pack are the Vista clients running vs the XP clients?

    Are you getting prompted to log in, or does it just fail immediately?

    Is it possible to troubleshoot this in conjunction with the Network / Desktop Administrator? Are you able to get your IT people involved in trying to get this resolved? It may expedite the process...

    At the moment we have a symptom that might be caused by: OS Settings, Browser Settings, Browser Addons, AAM's, MOSS Server settings, IIS settings, Kerberos settings or Office Security Settings.
    The only thing we've eliminated while trying to troubleshoot this with you is the Service Pack levels in Office, and I'd still like to double-check the version and patch levels between a working system and a non-working system to see if they are the same...

    Thanks
    Brad


    Brad Saide
    bsaide[replace with @]exemail.com.au
    http://sharepointblogs.spaces.live.com
    Tuesday, June 02, 2009 11:58 AM
  • Hi Brad,

            Thanks for your reply. i have already tried with the Yagyashree's suggestions  before doing this forum posting.

            i have check with 3 other users and they are having the issue. ( i said i m not sure, since those people doesnot perform the actions at there end )

            i will check for security settings for excel  and using
     vista SP 1 is used.

             i have a doubt regarding what happens when we perform the export to excel action. 

             i will try to explain my doubt with an example. see if i am logging to the machine with USER A credentials and  i am login to the sharepoint site with another credentials (USER B)  when i try  to perform the export to excel normally the windows application will get accessed and the windows application will be using the windows identity (USER A) 

               if USER A doesnot have any permissions on the site will it provide with the error that it cannot connect to the server. 

            i got the doubt after reading one forum thread which explain a scenario similar like this.

             if such a scenario exists what are the possilbe ways to avoid it, ie to make the windowws application ( word, excel, powerpoint etc) to use the USER B credentials.

    Regards,

    Aj. 

    Tuesday, June 02, 2009 4:34 PM
  • Please try the above scenario with system account.
    Visit: http://yagyashree.wordpress.com MCP & MCTS [WSS 3.0/MOSS]
    Tuesday, June 02, 2009 4:36 PM
  • What appears in the error log when the error occurs? Check the Application log, the security log (to see if there's an authentication issue) and the SharePoint logs.

    Also, check the logs on the local machine to see if somthing s being recorded at that time.

    What browser version and service pack are the Vista clients running vs the XP clients?

    I just Googled er sorry, Binged the issue (doesn't have the same "ring" to it), and it seems that the people who find a resolution always seem to identify their issue is with either the SSL certificates or an incorrectly set up Alternate Access Mapping - The SSL Certs are something we have not yet investigated. Might be worth checking these too...

    Brad Saide
    bsaide[replace with @]exemail.com.au
    http://sharepointblogs.spaces.live.com
    Wednesday, June 03, 2009 9:52 PM
  • Hi,

           Brad and Yagyashree , thanks for all the support and help,

           The issue resolved on a temporary basis: :) 

           Here's how it can be done :  Open an excel file on the computer.

                                                     Copy some contents from the sharepoint site to the excel file

                                                     It will ask for password prompt, provide the sharepoint identity.

                                                     Go to the sharepoint list , perform export to excel,  it works like charm.


      Once again - Thanks for all the help from you buddies, it was exactly the windows- sharepoint identity confilict  as i suspected. ( Rare Conspirasy : )  

    Regards,
    Aj.

     

    • Marked as answer by Ajith George Wednesday, June 10, 2009 1:27 PM
    Wednesday, June 10, 2009 1:26 PM
  • Hi All ,

    The above solution is not working for me . I could export to excel in intranet site using http://...... . The same is not working with internet site. i tired teh above given solutions and couldnot resolve the issue. I am using windows server 2003 OS and the problem perisist with other OS versions as well.

    Please suggest some resolution.

    Regards
    Vanaja

    Friday, January 22, 2010 5:45 AM
  • I have exactly the same problem as Vanaja with an https: sharepoint site.
    • Proposed as answer by KevinB201 Thursday, June 03, 2010 5:18 PM
    • Unproposed as answer by Mike Walsh FIN Tuesday, February 01, 2011 4:37 PM
    Thursday, February 18, 2010 8:41 PM
  • Sorry, first time in and thought it said "propose AN answer".

    I have had the same error and what I did to resolve the issue was this:

    In IE8, go to Tools->Internet Options->Advanced Tab.

    Scroll down to the Security Settings area and UNcheck the following option:

    "Check for server certificate revocation"

    Then restart IE.

     

    Moderator Note: Never propose your own posts as answers. The "Propose as Answer" function is for people to propose the good answers of other people. It is not for self-proposing.

     

    • Proposed as answer by KevinB201 Thursday, June 03, 2010 5:25 PM
    • Unproposed as answer by Mike Walsh FIN Tuesday, February 01, 2011 4:38 PM
    • Edited by Mike Walsh FIN Tuesday, February 01, 2011 4:39 PM Moderator Note added
    Thursday, June 03, 2010 5:22 PM
  • OMG You're a genius and life saver KevinB201!  Your solution did the trick and solved a problem that has been plaguing me ages!
    Wednesday, July 14, 2010 6:39 PM