Office 2016 redirected hyperlinks cause sign-in prompt and error

Overview: You have migrated your on premise SharePoint content to the cloud, on your old on premise SharePoint server you added a redirector that routes request to the corresponding location on the cloud. User opens an Office document that contains hyperlinks to locations on your old on premise SharePoint server.  When user CTRL + clicks on…

0

Excel 2016 Default save location gives error

Overview: You have Excel 2016 and try to change the default save location to a SharePoint location and get error: “Cannot access directory ‘http://myserver/mydoclib’ The setting is on the Excel Options Window, Save section, “Default local file location:”  (see picture below) Cause: For some unknown reason, some Office 2016 installs fail to create a needed…

0

Custom protocol handler to open text documents in Excel

Summary: You want to be able to open select text files in Excel instead of the configured text editor for the system. Solution: This blog post contains a custom protocol handler that will open any file type in Excel. For example once the custom protocol handler has been deployed (see below for more info) you…

0

Chrome downloads Office files instead of opening a live server document when opened via a URL

Summary: You have a SharePoint generated email containing a hyperlink or you paste a URL like http://sp2013ocsi/Shared%20Documents/DateTest.docx into the Chrome browser. When the above happens, Chrome downloads the document, instead of opening the rich client Office application that opens a live server document.   Cause: This is how Chrome works. Workaround: If you add ?web=1 to the…

0

Visio 2016 does not save to SharePoint Online

Summary: SharePoint Online opens Visio 2016 documents as read only from document library’s.  Visio handles read only drawings poorly and users are unable to save any changes back to the server.  Users must save to a local directory then upload the file back to SharePoint.   Cause: This is a software defect.   Workaround: Open the…

0

Office 2016 does not show SharePoint Title property as being required when it should

Summary: You have a SharePoint document library where the “Title” property is required and you are using an Office 2016 application.  When you try to save the document you get an error saying that: “This file cannot be saved because some properties are missing or invalid. Use the document properties under the File menu to provide…

0

Office 2016 O365, Get Visio and Project MSI to work via Citrix

Summary: Office 2016 O365 uses click to run (C2R) deployment technology.  It is not possible to have Office 2016 C2R installed on a computer that also has 2016 MSI products on it, like Visio and Project.  Some customer want to be able to leverage an existing investment they have in 2016 MSI products by making them available…

0

Linked SharePoint metadata columns can’t be edited in version 16.0.7167.2040+ of Office client applications

Update: **This issue is now resolved, in build 16.0.7369.2054. Issue: Managed metadata SharePoint document properties can not be edited in the rich client Office applications starting in build 16.0.7167.2040, this is a defect and not by design. Screen shot of working (prior to 7167) Not working (7167+) Workarounds: Roll back the Office 2016 client to…

0

Visio Viewer 2016 does not open from SharePoint

Summary: When a SharePoint document library is set to open in client application and the full Visio client is not installed, when the Visio document is clicked on you may receive a message to search the store for applications that support ms-visio   Workaround: Instead of clicking on the document link pick to “view in…

0

Visio 2013 Org Chart Wizard Crashes when Office 2016 is installed

Summary: You have Office 2016 installed and have Visio 2013 installed.  When using the Visio Organization Chart Wizard to fetch data from Exchange Server, Visio Crashes.   Cause: There is an incompatibility with this feature and Office 2016, the Visio 2013 Organization Chart Wizard was designed to work with Outlook 2013.   Workaround: The Visio version…

0