Microsoft Forms – Disabling User Licensing via PowerShell.

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…

1

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