Sharepoint Insight by Namwar Rizvi

July 18, 2008

How to get rid of Login prompt while opening documents in Microsoft Office

Filed under: Security, Uncategorized — namwar @ 10:33 pm
Tags:

If you are using Sharepoint as your document repository, you may came across with a situation where your users are prompted for login credentials whenever they try to open any document of document library in Microsoft Word. This is very irritating and can ruin the objective of user productivity.

You can resolve this issue very easily. It happens actually if your Sharepoint site is not in the trusted zone of IE. You can verify this by looking at the bottom right of your browser window as follows:

Internet zone icon

If you see the word “local intranet” or “Trusted sites” then only you can open your documents without getting prompt of login credentials. Just add your Sharepoint site into the “Trusted sites” zone and bingo! MS Word will stop prompting you for your credentials. Enjoy!

3 Comments »

  1. Your blog is interesting!

    Keep up the good work!

    Comment by AlexM — August 17, 2008 @ 1:29 am | Reply

  2. This is not always the case. Word/Excel/PowerPoint documents are prompted, non MSFT documents are not – even with trusted sites.

    In my world, users are authenticated against AD connecting to the website via SSL connection. https://mysite.com – after the user logs in and trys to get a document in the document library they are prompted again to enter the creds… but only on MSFT documents, .pdfs or .txt no prompt. We can’t add any reg key as the majority of users come in from outside our domain and we can’t change their desktop. Ideas?

    Comment by JasonR — January 8, 2009 @ 10:33 pm | Reply

    • If Sharepoint Shared Workspace is enabled in MS Word this may prompt users with a Windows login if users do not have permissions to access or create a Shared Workspace. Do the followoing to turn this off:

      1. Open MS Word
      2. Go to Tools/Options
      3. Click General Tab
      4. Click Service Options
      5. Click Shared Workspace
      6. Uncheck box that says “The document is part of a Workspace or SharePoint Site.”
      7. Click OK
      8. Click OK
      9. Try to hit a MS Word document from the SharePoint site.

      If this resolves issue repeat steps with every MS Office program to eliminate the prompt. (Excel, PowerPoint, Visio, Outlook)

      http://office.microsoft.com/en-us/word/HP010414641033.aspx

      Comment by Davis — July 30, 2009 @ 3:01 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a comment

Blog at WordPress.com.