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…

0

Sway – File Size Limit error

You may receive the following error when trying to add content to Sway by uploading a file:     The maximum supported file sizes are: 20 MB for documents, 100 MB for audio files, and 256 MB for other types of content Sway has file size limits for different types of files. There is no…

0

Excel Online – Open large workbooks in the browser.

Many of you have most likely uploaded large workbooks and have seen the message. “Couldn’t Open the Workbook Sorry, we can’t open your workbook in Excel Online because it exceeds the file size limit. You’ll need to open this in Excel.” When searching online, you will see that there is a 10 MB limit for…

0

Office Online – Versioning behavior while in co-authoring state

I was contacted by a customer who had explained that they were not seeing new Minor Versions after "X" number of versions.  They told me the version was being stuck at 1.06 and that version kept being overwritten.  I was a little perplexed, so I asked 3 of my co-workers (4 of us total) to join a co-authoring session…

0

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…

0

Office Online – Allow people to use third-party hosted storage devices.

March 2016 Update:   We have re-enabled Dropbox Integration:   Enable third-party storage in Office 365https://support.office.com/en-us/article/Enable-third-party-storage-in-Office-365-59302e31-e05b-4855-8c51-e980112ce0b9?ui=en-US&rs=en-US&ad=US     Problem Description: User goes out to http://office.com and signs in with an Office 365 Account.  User selects one of the office apps links on the page. The office app will try to launch in the browser and…

8

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…

0

Excel Online – Refreshing Data to a SQL Azure Database

Below are the steps to connect to SQL Azure Database and refresh this Data in Excel Online. 1. Open the Excel Rich Client > Data > From Data Connection Wizard > From Data Connection Wizard 2. Choose Other/Advanced 3. Choose SQL Server Native Client 11.0 Note: if you do not have see SQL Server Native…

0

Excel Online – Refreshing data from an Access Online App (SQL Azure Database).

If you want to refresh the below Access Online data in Excel Online. You will need to carefully create an Excel workbook.  But before you do that, you will need to know your Read-Write Connection Information To view this Open your Access Database > File > Connections > Manage From Any Location Enable Read-Write Connection View Read-Write…

0