Excel Online – External Users cannot refresh data connections

Scenario: You’re using an Excel file that contains a Excel Power Pivot Model with external data connections and currently the data refresh in Excel Online is working without any issues for the internal users of the organization tenant. When this file is shared with external users of the tenant, this users are not able to…


Excel Online – “Sorry, we couldn’t open this link. The link address may be invalid, or you may not have permission to open it.”

I have found that when you enter a hyperlink into Excel Online, open in the Excel Rich Client, Save, and then re-open in Excel Online, the hyperlinks are updated and subsequently broken. So if you enter a hyperlink (in Excel Online): https://contoso.sharepoint.com/Documents/2017 Financials.xlsx?d=<guid> it will be changed to a relative link:  2017 Financials.xlsx?d=<guid> and you will see…


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…


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…