Permission & Access Issues

Fix SharePoint Error: User Cannot Be Found in the Directory

Chanuka Geekiyanage Oct 1, 2026 872 views

Question details

External users are unable to access shared Excel data or files via invitation links and receive a 'User Cannot Be Found in the Directory' error.

How to Fix SharePoint Error: User Cannot Be Found in the Directory

Product: SharePoint / Excel
Device & OS: not provided
Scenario: Attempting to access shared SharePoint files or Excel data as an external user using a guest account invitation link.
Observed behavior: The system blocks access and displays an error message stating that the user cannot be found in the directory, despite receiving a sharing link.

Before you start

Ensure you have tenant administrator privileges for Microsoft Entra ID and SharePoint, as resolving this directory mismatch requires deleting and recreating guest user profiles at the administrative level.

Solution 1Recommended

Reset the External Guest Account and Clear Permissions

This method resolves directory synchronization issues by completely removing the corrupted or incomplete guest profile and issuing a fresh invitation.

This error generally occurs when an external guest account is not fully configured or synchronized correctly within the tenant. Recreating the account ensures that Microsoft Entra ID and SharePoint recognize the external user properly.

Remove the guest user from Microsoft Entra ID

Sign in to the Microsoft Entra admin center as an administrator. Navigate to Users > All users, search for the external guest account experiencing the error, and delete the account.

Delete the SharePoint user profile

Open the SharePoint admin center, navigate to 'More features', and select 'User profiles'. Search for the external user's profile and delete it from the system.

Clear specific site permissions

Go to the SharePoint site where the Excel data is hosted. Click on the gear icon, select 'Site permissions', then 'Advanced permissions settings', and remove the external user from any permission groups.

Re-invite the user

Return to Microsoft Entra ID and send a new guest invitation to the external user's email address.

Accept via an Incognito window

Instruct the external user to copy the new invitation link and open it in an InPrivate (Edge) or Incognito (Chrome) browser window. This prevents cached credentials from causing login conflicts.

Reset the External Guest Account and Clear Permissions

Administrator Action Required: Standard users cannot perform these steps. If you are an external user experiencing this error, you must contact the organization's IT support or SharePoint administrator to reset your guest account.

Free Microsoft Office alternative

Use WPS Office for Hassle-Free Document Sharing

Tired of dealing with complex directory settings, tenant permissions, and access errors? WPS Office offers a streamlined, lightweight alternative for viewing, editing, and sharing Excel spreadsheets and other documents effortlessly.

1. Open your file in WPS Office: Launch WPS Spreadsheet and open the document you wish to share with external collaborators.
2. Click the Share button: Locate the 'Share' button in the top right corner of the application interface.
3. Create a sharing link: Set your desired permission level (such as 'Anyone with the link can view/edit') and instantly copy the link to send to anyone without worrying about directory errors.

Fully compatible with Microsoft Excel (.xlsx, .xls) and other major Office formats.Lightweight architecture ensures fast performance even with large datasets.Simple cloud-based link sharing without the need for complex directory or guest account configurations.Familiar user interface requires no steep learning curve for new users.

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint say my guest account cannot be found?

This error typically occurs if your guest account was not properly provisioned in Microsoft Entra ID, the initial invitation was not fully accepted, or there is a synchronization mismatch between the SharePoint user profile and the directory.

Can a standard user fix the SharePoint directory error?

No. Resolving this specific directory error requires tenant administrator privileges to remove and recreate the guest account in Microsoft Entra ID and the SharePoint admin center.

Why should I use an Incognito window to accept the SharePoint invitation?

Using an InPrivate or Incognito window prevents your web browser from automatically attempting to log in using cached credentials from other Microsoft accounts, ensuring the guest invitation is successfully linked to the intended email address.

Will recreating the guest account delete the files I previously shared?

No, deleting and recreating the guest account only resets the user's access permissions. The actual Excel data and files stored in SharePoint will remain completely intact.

Document & File Issues