Microsoft 365 Error Codes

How to Fix Excel Error CAA20002 When Opening a Shared File

Muhammad TalhaMuhammad Talha Nov 2, 2026 870 views

Question details

A user is encountering error code CAA20002 in Office 365 when trying to open a specific shared Excel workbook, despite being able to open other files without issues.

How to Fix Excel Error CAA20002 When Opening a Shared File
Product
Microsoft Excel (Office 365)
Device & OS
not provided
Scenario
Accessing a specific shared Excel workbook hosted by another user or organization.
Observed behavior
The application prompts the user for a sign-in, fails to authenticate, and returns error code CAA20002. Standard troubleshooting like signing out and back in does not resolve the issue for this particular file.
Before you start

Verify whether the problematic shared file is stored locally, on a personal OneDrive, or a corporate SharePoint server. Additionally, check if other users in your organization are experiencing the same error when accessing this specific file to rule out a broader network or tenant issue.

Solution 1Recommended

Verify Cross-Tenant Access and File Permissions

Error CAA20002 often occurs when a shared file belongs to a different Microsoft 365 tenant and your account lacks the necessary cross-tenant permissions to authenticate.

When opening a file shared by an external organization, your Office client must authenticate against their Azure Active Directory. If cross-tenant access is restricted or the sharing link is broken, the sign-in prompt loops and eventually fails with this error code.

1
Contact the file owner

Reach out to the person who shared the workbook and confirm if their Microsoft 365 account belongs to a different organizational tenant.

2
Request specific permissions

Ask the file owner to navigate to their SharePoint or OneDrive sharing settings, remove your current access, and re-add your exact email address with explicit 'Specific people' permissions.

3
Test via web browser

Have the owner send you a fresh sharing link. Open an Incognito or InPrivate window in your web browser, paste the link, and attempt to sign in with your credentials to see if the web version bypasses the desktop client error.

Verify Cross-Tenant Access and File Permissions
Admin Intervention: If cross-tenant access is blocked by conditional access policies, the IT administrator of the host organization may need to safelist your domain.
Free Microsoft Office alternative

Use WPS Office to Open Excel Files Seamlessly

If Microsoft 365 authentication errors like CAA20002 prevent you from accessing crucial workbooks, WPS Office provides a lightweight, highly compatible alternative. You can easily view, edit, and collaborate on Excel files locally without getting blocked by complex cross-tenant access policies.

  1. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Download the shared file locally: If possible, download a local copy of the shared .xlsx file from your email or web browser.
  3. 3. Open with WPS Spreadsheets: Launch WPS Office, click 'Open', select your downloaded file, and bypass the Microsoft authentication loop entirely.
100% compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Bypass Microsoft 365 tenant authentication bugs for locally downloaded shared files.Lightweight installation with a familiar spreadsheet interface for instant productivity.Completely free to download and use for all your essential editing tasks.
microsoft office alternative - wps office

Frequently Asked Questions

What does error code CAA20002 mean in Microsoft 365?

Error CAA20002 is an authentication and sign-in error in Microsoft 365. It indicates that the client application (like Excel) is unable to acquire an access token to authenticate the user, often due to server disconnects, cached credential conflicts, or tenant permission blocks.

Why does the CAA20002 error only happen with one specific shared file?

If only one file is affected while others open normally, the issue is typically linked to the file's specific sharing permissions. This usually happens when the file is hosted on an external organization's restrictive SharePoint site or belongs to a different tenant that blocks your account from authenticating.

Will reinstalling Microsoft Office fix the CAA20002 error?

Reinstalling Office is usually unnecessary for this specific error. Because the root cause is tied to account authentication and file permissions, clearing your Windows credentials, generating a new sharing link, or signing out of all Office accounts will resolve the issue much faster.