Microsoft Group Forms

Leave a comment

Microsoft Forms is a great tool to create fast and re-usable forms or Quizzes.

Description from :

« With Microsoft Forms, you can create surveys, quizzes, and polls, and easily see results as they come in. When you create a quiz or form, you can invite others to respond to it using any web browser, even on mobile devices. As results are submitted, you can use built-in analytics to evaluate responses. Form data, such as quiz results, can be easily exported to Excel for additional analysis or grading. »

It is important to understand that when a user creates a new form by accessing the form service from or from the App Launcher, it will create a personnal form.

Important : All personal forms will be deleted when the user account is deleted.

New Group Forms

We can now create Team or Group Forms, that will be attached to the Group (not just the user)

Group Forms will not be deleted when the user account is deleted.

A Group form can be created from:

Microsoft Teams Client

  • Click on a Team
  • Click on a Channel
  • Click on Files
  • Click New
  • Click Excel
  • In Excel online click Forms
  • Click New From ( I know, it’s not very intuitive at the moment, but it’s in preview)

  • The Excel document will be stored in the groups SharePoint document library

Group forms can also be created from the SharePoint site that is tied to the group

  • Access the SharePoint site
  • Go to the document library
  • Click New
  • Click forms from Excel
  • The Excel document will be stored in the groups document library

Note: At the time of writing this article, forms for Excel are not available Communication sites. They are only available in Microsoft Teams, In SharePoint site tied to an Office 365 group or Team, or from OneDrive For Business (personal forms)

Where do I find my group forms

From the Forms service you can now see the personal forms (My forms) and the group forms (Recent group forms).

Note: Under Recent group forms, you will see only the group forms that you have edited or created.

Information on how to create a form:

Microsoft Forms is in public preview mode, this means that it can cane without notifications.

This article reflects the state of group forms as of March 28th 2018.

Happy Form!

Excel Co-authoring requirements

Leave a comment

Microsoft Excel (Desktop application) allows to have multiple users to work on the same document at the same time (co-authoring). This is a great feature, but it might not be available for you…

What you need to co-author?

  • You need an Office 365 subscription.
  • You need the latest version of Office installed. (Important)
  • You need to sign in to Office with your subscription account.
  • You need to use Excel Workbooks in .xlsx, .xlsm, or .xlsb files. If your file isn’t in this format, open the file and then click File > Save As > Browse > Save as type. Change the format to Excel Workbook (*.xlsx). Please note that co-authoring does not support the Strict Open XML Spreadsheet format.

Latest version of Office

Excel co-editing was introduced in July 2017. This explains why Excel co-authoring might not be available for you (if you don’t have the right version).

On top of the version number,
Co-authoring and autosave are not yet supported for customers who are on the FRDC or SA (semi-annual) release channel. These features are only available for customers on the current channel (CC).  (Even if your Office version is higher than 1707.8326.2058…)

To see the the type of update that your office subscription is on :

  • Open Excel
  • Goto Files
  • Click on Account
  • Look for Subcription product

If you are on Semi-annual Channel, Excel desktop application Co-authoring will not work.

You have to be on Current Channel

The update channels can be controlled by your Administrator, you might not have to option to change this.

More information on update channels

Version and build numbers of update channel releases

Hope this helps you understand.

New Yammer Group Categories

Leave a comment

Microsoft is planning to add categories to Yammer groups.

During the creation process of a Yammer group, you will eventually be able to add a category to your group. It’s not clear as to what categories are going to be available as there are two different articles from Microsoft showing two different types of categories. And it’s not clear yet as how you will be able to manage the categories.

Source :

Source :

The categories will make it easier to find the type of groups you are looking for.

The category will be shown in the left navigation bar and on the group header. (see image below)

For more information see these two articles :

Visibility of Private Microsoft Teams

Leave a comment

You will have to be carefull if you think that a private Team should be private, meaning that no-one should see it. A user needs to be invited or approved to see the content of a private Team. A new change to Office 365 will make the private teams discoverable via search and Suggested Teams. If you have private teams with sensitive information in Nams or Description you might want to tell your users to rename them. See below.

Note : It might be already like this on your tenant…

Major update: General Availability rollout started

Applied to: All customers


Starting March 23, 2018, private teams will be searchable in Microsoft Teams. This feature update will make it easier for people to share and join Teams.

[How does this affect me?]
Until now, it was not possible for users to find and request access to a private team in the Teams app. Users had to either be invited to a team or search for the underlying group in Outlook in the Outlook app.

Now, private teams will be discoverable via search and the Suggested teams gallery, making it easier to share and discover private teams across an organization. If a user requests to join a private team, the team owner will receive a notification and can approve or deny the request directly in Teams.

[What do I need to do to prepare for this change?]
We recommend that you inform team owners about this change. If team names or descriptions include sensitive information, team owners may want to update them before this change occurs on March 23, 2018.

If you wish to hide a private team or group, Office 365 admins can use the Set-UnifiedGroup PowerShell cmdlet to hide specific groups or teams
(in Outlook, Outlook Web App, and Microsoft Teams). Specifically, use the HiddenFromAddressListsEnabled parameter, which you can apply to individual groups. For further instructions, please click Additional Information below.