How to Fix Excel Error CAA20002 When Opening a Shared File
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.

- 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.
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.
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.
Reach out to the person who shared the workbook and confirm if their Microsoft 365 account belongs to a different organizational tenant.
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.
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.

Clear Windows Credentials for Microsoft Office
Corrupted or conflicting cached credentials on your device can cause persistent sign-in loops and authentication errors for specific shared files.
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. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Download the shared file locally: If possible, download a local copy of the shared .xlsx file from your email or web browser.
- 3. Open with WPS Spreadsheets: Launch WPS Office, click 'Open', select your downloaded file, and bypass the Microsoft authentication loop entirely.

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.




