Create custom File Explorer Side Bar item

Overview: Some users opt to not have the Office Client installed at all and just to use the Office web applications.  In this scenario there is no OneDrive sync client installed and no shortcuts appear in the File Explorer navigation.   This blog post will provide a tool and instructions for a custom OneDrive like…

0

Remove Office Add-in references from “Recently Used Add-ins” area of Office 2016

Overview: Currently there is no way to remove an App for Office add-in reference from Office 2016 (see below). These add-in references are stored in the registry under a combination value that includes the add-in’s ID GUID.  This ID can be seen in both the add-in manifest and in the SharePoint Online application catalog (see…

0

Excel 2013 / 2016 does not open XML files from SharePoint

Overview: You have Excel files in .XML format (XML Spreadsheet 2003) and you get error “This action couldn’t be performed because Office doesn’t recognize the command it was given.” When you try to open the file from a SharePoint document library. There will likely not be a product change to address this issue, it is…

0

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

**4/17/2017 UPDATE  this issue will be resolved in the May 2017 update to Visio Click To Run 2016. 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…

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