Microsoft Office applications prompt for user credentials when associated file types are loaded from SharePoint (xlsx, docx, etc). Is there any way to pass through the Windows login credentials so users do not have to type their username and passwords into each Microsoft Application? If not – is there a setting to increase the length of time which the entered credentials are cached so that users do not feel they are constantly retyping their AD credentials?
The Office application is trying to access the document directly from the server which has to communicate with the server to determine what type of server that's accessing the file and what web authoring protocol is available.
Anytime a new process tries to access the server, the Office application will require renegoiation.
There are different resolutions depending on if users are within the network and if direct editing is needed.
If you are in the intranet, you can configure the server to use Integrated Windows Authentication and then configure the client to enable automatic logon. The Local Intranet zone has a default configuration of automatic logon with the current user name and password.