Knowledgebase
Unable to open Microsoft Office 2010/2013 files in SharePoint
Posted by Jay Allred on 21 January 2014 03:31 PM

Office 2010 and Office 2013 have a feature that does not allow Office applications such as Excel and Word to open documents from SharePoint sites that are not secured via SSL. 

BizCom always recommends that your site runs with the proper SSL certificate for data encryption purposes.  We recommend that you have your primary contact speak with your BizCom representative about upgrading your site to operate under SSL.  If your company chooses to continue not to operate with security certificates then below is a work around.  The work around DOES NOT FIX THE SECURITY PROBLEM but does allow you to open and edit Office files.

Please also note that though the article talks about basic authentication, all authentication to Hosted SharePoint 2010 is via Windows Integrated Authentication using NTLM. Though NTLM is more secure than basic authentication BizCom still recommends running your site under SSL. 

Windows 7/8/8.1

  1. Click Start and type regedit in the Start search box to open the Registry Editor (Or, in Windows 8/8.1 go to the Start screen and just start typing regedit)
  2. Locate the following registry key:
    1. Office 2010 - HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Common\Internet
    2. Office 2013 - HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Internet
  3. Right click Internet and click New > DWORD (32-bit) value
  4. Type BasicAuthLevel for the name
  5. Double-click BasicAuthLevel and type the number 2 in the value box
  6. Exit Registry Editor and reboot

NOTE: YOU MUST CLOSE ALL OFFICE PROGRAMS IN ORDER FOR THE CHANGE TO TAKE EFFECT.

(0 vote(s))
Helpful
Not helpful

BizCom Web Services, Inc., Copyright© 2015, All Rights Reserved  -  Main: (866) 253-4316 | Fax: (919) 855-8856 | sales@bizcomweb.com