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…


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…


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…


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…


Excel Online – Request Was Taking Too Long

The error "Request Was Taking Too Long" when launching a workbook in Excel Online is caused when the workbook takes longer than 30 seconds to open in Excel Online. Our Excel Rich Client team has a great article on this: How to clean up an Excel workbook so that it uses less memory                https://support.microsoft.com/en-us/kb/3070372 If you…


Excel Online – "Unable to Set One or More Parameters" when connecting "Excel Web Access Web Part" and "Current User Filter"

I recently came across the error: I was connecting a Current User Filter to an Excel Web Access Web Part I was trying to pass the User's Login Name via the Current User Filter to a Parameter in an Excel Web Access WebPart. I first created a workbook that contained a Pivot Table and then gave one of…


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…


Excel Online – Guest Link – This workbook contains external data connections or BI features that are not supported.

Guest user have been encountering the below error when clicking on Slicers in a SharePoint Online PowerPivot workbook. "Excel Online – This workbook contains external data connections or BI features that are not supported." Here are the steps they are following: The URL ends up looking like this: https://tschauer-my.sharepoint.com/personal/admin_tschauer_onmicrosoft_com/_layouts/15/guestaccess.aspx?guestaccesstoken=DT4MuQV804mm5ydYzfQK1mmjlwGxzrWjrw8kdj%2bFEsU%3d&docid=0dc2bc40c4f484f1da7d7b30b0cc4286b If the workbook Slicers are hitting…


Excel Online – This workbook contains external data connections or BI features that are not supported.

If you are seeing the below error when uploading an Excel workbook containing a data model, you need to toggle a SharePoint Online Feature. "Excel Online – This workbook contains external data connections or BI features that are not supported." The feature you need to toggle is the Preview Features. “The preview feature is an…


Excel Online – Data Refresh may time out

When using an OData Connection inside Excel, refresh may time out if the amount of data being refresh is very large. Depending on the amount of data attempting to be refreshed the refresh can take several minutes. By default the Excel Session Timeout setting is set to 450 seconds (7.5 minutes), so if your refresh…

3