Sometimes when you click any link in a Microsoft Office program like Excel or Word it takes a long time to open. If you are having this problem, this article may help.
Word or Excel hyperlinks are slow to open
If Microsoft Office Word or Excel hyperlinks are slow to open, under usual circumstances, or when they point to Microsoft AD FS Server, try these suggestions:
- Open Word (or Excel) options
- Click on Advanced
- Locate the Save section
- Select the Copy files stored remotely to your computer check box
- Click OK and exit.
Word or Excel hyperlinks are slow to open AD FS sites
Active Directory Federation Service (AD FS) enables single sign-on functionality that provides customers with a simplified user experience while accessing an organization’s web applications. However, sometimes when you try to access such sites through hyperlinks in Microsoft Office applications like Word or Excel, the sites take at least 60 seconds to open.
This problem arises mainly for the following 2 reasons. First, ADFS is not equipped to handle a HEAD request that it receives from Word or Excel applications. Second, although AD FS attempts to respond by returning an error message, AD FS rejects it because the HEAD response cannot contain a request body. To fix it, try the following:
- Open the Windows Registry Editor.
- Move towards Office 16.0 Common Identity.
- Add DWORD: ReplaceHLinkHEADRequestParGET.
- Change the value to 1 (hexadecimal for the base).
- Close and exit Registry Editor.
- Restart the PC.
Open the Windows Registry Editor. For that, press Win + R in combination to bring up the ‘To run‘ dialog box.
Type ‘regedit’ in the empty field of the box and press’Enter‘.
When Registry Editor opens, navigate to the following path address –
Create a new registry key – DWORD – ReplaceHLinkHEADRequestParGET.
Double click on the entry and change its default value ‘0’ to ‘1‘.
When done, close the registry editor and exit.
Restart your computer. Your problem should be solved and it should not take long for Office applications like Excel, Word to open AD FS sites.