Sharepoint Insight by Namwar Rizvi

Sharepoint Tips, Tricks and inside knowledge from real world experience by Namwar Rizvi

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

Posted by namwar on July 18, 2008


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!

Advertisements

4 Responses to “How to get rid of Login prompt while opening documents in Microsoft Office”

  1. AlexM said

    Your blog is interesting!

    Keep up the good work!

  2. JasonR said

    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?

    • Davis said

      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

      • Pricey said

        Im sorry but I am struggling with word 2007. I am locked out of my own document and it now says I dont have the credentials to open the document. I login through hotmail and go through all the way until the end where it says i dont have the credentiials. I was ok with office 2003 and understand your instructions there as i knew where all the tabs are but im lost with 2007. Can I get myt document opened?

        Really appreciate your help

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: