File Sharing Problems

How to Fix External OneDrive Sharing Errors in Excel

Maira Mehtab Sep 21, 2026 869 views

Question details

The user needs to resolve an issue where sharing an Excel file via OneDrive fails due to an external address directory error.

Product: Microsoft OneDrive / Excel
Device & OS: not provided
Scenario: Attempting to share an Excel spreadsheet with external clients who are not part of the organization.
Observed behavior: An error message is displayed stating that the external address cannot be found in the tenant's SharePoint directory, which prevents the file sharing process from completing.

Before you start

Verify the exact email addresses of your external clients and confirm whether your organization has recently updated its Microsoft 365 security or Entra ID (formerly Azure AD) policies.

Solution 1Recommended

Contact IT Administrator to Add Users via Microsoft Entra B2B

This is the most effective solution if your organization has recently migrated to SharePoint and OneDrive integration with Microsoft Entra B2B, which requires external users to have dedicated guest accounts.

When a Microsoft 365 tenant moves away from the one-time passcode experience, all external clients must be authenticated as guest users. If they are not in the directory, OneDrive blocks the sharing attempt.

Identify your Administrator

Reach out to your Microsoft 365 tenant administrator or your company's IT support department.

Request Guest Account Creation

Ask the administrator to add the external client's email address as a guest user in the Microsoft Entra ID (B2B) directory.

Client Accepts Invitation

Instruct your external client to check their email for a Microsoft invitation and accept it to establish their guest access.

Retry Sharing

Once the client is registered in the tenant's directory, open your Excel file in OneDrive and try sharing it with them again.

Solution 2

Request IT Administrator to Re-enable One-Time Passcodes

Use this approach if adding guest accounts for every individual external client is not feasible for your organization's workflow.

Free Microsoft Office alternative

Share Files Seamlessly with WPS Office

Avoid complex tenant directory configurations and Microsoft Entra B2B setups. WPS Office provides an easy, lightweight, and free alternative with its own built-in cloud capabilities. You can effortlessly share spreadsheets via links with anyone, without dealing with restrictive guest user directory errors.

1. Open your Spreadsheet: Launch WPS Office and open the spreadsheet you want to share.
2. Click Share: Click the 'Share' button located in the top right corner of the application window.
3. Configure Link Permissions: Select 'Create Link' and adjust the permission settings to 'Anyone with the link can view' or 'edit'.
4. Send to Client: Copy the generated link and send it directly to your external client via email or messaging app.

No complex tenant or guest user directory setup requiredHighly compatible with Microsoft Excel (.xlsx) formatsLightweight and completely free to useShare documents instantly via secure links with customized permissions

microsoft office alternative - wps office

Frequently Asked Questions

Why did this OneDrive sharing error suddenly start appearing?

This usually happens when your organization's IT department updates Microsoft 365 security policies, specifically shifting from one-time passcodes to Microsoft Entra B2B integration. This new policy restricts sharing strictly to verified guest users existing in the tenant directory.

Can I fix the tenant's SharePoint directory error myself?

Generally, no. Unless you have Microsoft 365 Administrator privileges for your organization, you cannot modify directory settings. You will need to contact your IT team to add the external user to the directory or adjust the sharing policies.

Is there a way to share the Excel file without changing admin settings?

If OneDrive sharing remains blocked by tenant policies, you can download a copy of the Excel file to your local drive and send it to your client as an email attachment, provided your company's data protection policies allow sending files via email.

Document & File Issues