File Sharing Problems

How to Share an Excel File with a Group Email Address

Ayan Masood Sep 25, 2026 869 views

Question details

The user wants to share an Excel file with a group of approximately 60 people to grant everyone editing access without adding them individually, but Microsoft 365 cannot find some group recipients.

How to Share an Excel File with a Group Email Address

Product: Microsoft Excel / Microsoft 365
Device & OS: not provided
Scenario: Attempting to grant bulk editing permissions to a large group of users via a single group email address in OneDrive or SharePoint.
Observed behavior: Microsoft 365 is unable to find or resolve the group email address in the sharing dialogue, preventing the user from sending the invite.

Before you start

Ensure you know the exact type of group you are trying to share with (e.g., Microsoft 365 group, security group, or simple distribution list) and verify your organization allows sharing files with external users if the group contains guests.

Solution 1Recommended

Verify Group Type and Adjust Sharing Settings

Check if your organization's sharing settings allow the specific group type and determine if external guests in the group are causing the resolution failure.

In Microsoft 365, only specific group types are fully supported for granting direct file permissions in SharePoint and OneDrive for Business. Simple distribution lists often cannot be used to assign permissions, while Microsoft 365 groups and mail-enabled security groups generally work.

Confirm the Group Type

Open the Exchange Admin Center or contact your IT admin to ensure the group address belongs to a Microsoft 365 group, mail-enabled security group, or standard security group.

Check for External Users

Open the group's member roster. If the group contains external users (guest accounts), OneDrive/SharePoint might block sharing if your site's sharing settings restrict external access.

Review Site Sharing Settings

Navigate to the SharePoint site or OneDrive settings gear icon, select 'Site permissions', and ensure that sharing with groups and external users is permitted by your organization's policies.

Verify Group Type and Adjust Sharing Settings

Alternative Method: If you cannot change the group type, you can generate an 'Anyone with the link can edit' link and email it directly to the group address.

Free Microsoft Office alternative

Easily Share Spreadsheets with WPS Office

If Microsoft 365 group sharing configurations are too restrictive or complex, WPS Office offers a free, lightweight alternative. You can easily share files using customizable link permissions without worrying about active directory group types or organizational restrictions.

1. Open your Spreadsheet: Launch WPS Office and open the spreadsheet you want to share with your group.
2. Create a Share Link: Click the 'Share' button in the top right corner and set the permission to 'Anyone with the link can edit'.
3. Send to the Group: Copy the generated link and paste it into a standard email addressed to your 60-person group.

Fully compatible with Microsoft Excel (.xlsx) and other Office formatsEasily share editable links to any group email address without backend restrictionsFree and lightweight with a highly familiar user interfaceBuilt-in cloud collaboration for real-time team editing

microsoft office alternative - wps office

Frequently Asked Questions

Can I share an Excel file directly to a distribution list?

Standard distribution lists are generally used only for email routing and are not always supported for assigning file permissions in Microsoft 365. It is recommended to use a Microsoft 365 group or a mail-enabled security group instead.

Why does Microsoft 365 say the group cannot be found?

This error typically occurs if the group contains external users and your sharing policies block external sharing, if the group is a standard distribution list instead of a security group, or if there is a synchronization delay in your organization's directory.

How can I share an Excel file with 60 people quickly if the group fails?

The fastest workaround is to create a shareable link. In Excel, select 'Share', change the link settings to 'Anyone with the link can edit', copy the link, and paste it into an email sent to the group address.

Document & File Issues