Excel Surveys for “Office 365 Groups”

I came across an interesting issue when trying to use an Excel Survey from an Office 365 Group.  Details below. If you create an Office 365 Group… …and build a Document Library (https://tschauer.sharepoint.com/sites/tomtest/TomTest_Doc_Library), you will NOT see Excel Survey under +New. For Excel Surveys to be present certain permissions need to exist in SPO, see…


Excel Online – Compatibility Report – Text Queries

This particular blog is going to handle how to deal with Text queries appearing in the Compatibility Report. "Compatibility ReportText QueriesBut you can see all the content in this workbook byOpening the file in Excel."   You can fix this several different ways. 1. Edit a Copy, which will remove the unsupported feature. 2. If you know where the Text…


Cannot add an "Excel Web Access" Web Part in SharePoint Online

  If you are not seeing the option to add an Excel Web Access Web Part under the Business Data Category:     Make sure to enable Custom Script under Admin > SharePoint > settings >   The new “Custom Script” (no-script) featurehttp://blogs.msdn.com/b/sridhara/archive/2015/04/02/the-new-custom-script-no-script-feature.aspx Turn scripting capabilities on or offhttps://support.office.com/en-us/article/Turn-scripting-capabilities-on-or-off-1f2c515f-5d7e-448a-9fd7-835da935584f As you can see, if this is…


OneNote Online – OneNote can't display some of your notebooks. Please try viewing them on OneDrive for Business.

I recently had several customers contact me and ask about an error they were seeing when trying to create a new OneNote Notebook. When they do this onenote.com will open, but it will throw an error: "OneNote can't display some of your notebooks.  Please try viewing them on OneDrive for Business." This is caused when OneDrive…