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

By Namwar Rizvi - Last updated: Friday, July 18, 2008 - Save & Share - 9 Comments

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!

Share
Posted in Security, Uncategorized • Tags: Top Of Page

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

Comment from AlexM
Time August 17, 2008 at 1:29 am

Your blog is interesting!

Keep up the good work!

Comment from JasonR
Time January 8, 2009 at 10:33 pm

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 from Davis
Time July 30, 2009 at 3:01 pm

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 from Pricey
Time May 8, 2010 at 8:34 am

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

Comment from NEO
Time September 29, 2010 at 3:32 pm

I had this problem in my box too.

I came out with this solution. No modules, nothing to install, no need to add it to trusted sites, no nothing. And of course, no need to disable client integration.

Just as simple as it is.

http://www.uv.mx/personal/gvera/2010/09/28/sharepoint-login-prompt-when-accessing-files-in-a-document-library/

Hope it helps.

Comment from Josie
Time December 1, 2011 at 1:45 am

What if you can’t trust your site because your domain name is the same internally and externally?

Comment from Guillermo Saldana
Time April 17, 2012 at 2:55 pm

NEO I tried to connect to your link but it’s not working? Could you send me the resolution you used?

Comment from Matt
Time June 22, 2012 at 4:06 pm

@Neo
You’ve posted this link on 500 web sites but it doesn’t work any more.

Comment from Alex Choroshin
Time November 8, 2012 at 1:40 pm

Hi,
We opened a service request and got a solution from Microsoft.
We got 3 possible ways to solve this issue.
Check out my article:
http://blogs.microsoft.co.il/blogs/choroshin/archive/2012/11/06/sharepoint-getting-authentication-login-prompt-when-trying-to-open-office-document-with-unique-permissions.aspx

Write a comment