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…

1

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

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