Delete a Group Form from Microsoft Teams

For a Group Form created in Microsoft Teams, you are unable to delete the Form directly from Teams. You will need to use the following steps to delete the Form.   1. Navigate to the Microsoft Forms site at https://forms.microsoft.com and sign in.   2. Click on Group Forms.   3. Click on Recent group…

0

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…


Forms response columns out of order

You may run into an issue in Microsoft Forms where the response columns are out of order in the response workbook for a Form when compared to the order of the questions on the Form. This is a known issue being investigated. The workaround is to go to the Responses tab on the Form, click…

0

No email notifications for responses to Group Forms

You may not receive email notifications for responses that are submitted for a Group Form, such as a Form created in Microsoft Teams. To receive email notifications, follow these steps:   1. Log into Forms at https://forms.office.com, and click on Group Forms.                          …

0

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…


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…


Sway – File Size Limit error

You may receive the following error when trying to add content to Sway by uploading a file:     The maximum supported file sizes are: 20 MB for documents, 100 MB for audio files, and 256 MB for other types of content Sway has file size limits for different types of files. There is no…

0

Excel Online – Open large workbooks in the browser.

Many of you have most likely uploaded large workbooks and have seen the message. “Couldn’t Open the Workbook Sorry, we can’t open your workbook in Excel Online because it exceeds the file size limit. You’ll need to open this in Excel.” When searching online, you will see that there is a file size limit for…