Many customers have asked how to disable “Microsoft Forms (Plan E3)” for all users via Windows PowerShell. Claus Schiroky created a PowerShell script found here. This was originally created for Sway, but can be used for Forms. Before running this, you may need to install the prerequisites: Microsoft Online Services Sign-In Assistant for IT Professionals RTW Download and…
Year: 2017
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 Online Refresh Fails to Project Online when using ‘TimeByDay (Month)’ PivotTable Field.
There is an issue when refreshing Project Online Data in Excel Online when using the TimeByDay (Month) Pivot Table Field. I will dive into why this is occurring and how to resolve it, but first I will explain the issue. This issue happens when you perform an Data > Refresh All > Refresh All Connections…
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…