Fix Microsoft 365 SharePoint File Authentication on an RDP Server
Question details
A user needs to open SharePoint files in Microsoft 365 apps from an RDP server without an authentication failure.

- Product
- Microsoft 365, SharePoint, and Microsoft Entra Conditional Access
- Device & OS
- not provided
- Scenario
- A user connects to a remote desktop server, accesses a SharePoint team site in Edge, and tries to open an Office file in a desktop app.
- Observed behavior
- The SharePoint site opens in the browser, but the Office app prompts for authentication and reports that the device or client application must meet management and compliance policies.
Note the affected account, the time of the failed sign-in, and the exact error message or correlation ID if shown. Ask a Microsoft Entra administrator with access to sign-in logs and Conditional Access policies to help investigate.
Find the Conditional Access policy blocking the Office sign-in
Use sign-in logs to identify why the desktop Office app is blocked even though the SharePoint site opens in a browser.
In the RDP session, open the SharePoint site in Edge and select an affected file to open it in the desktop Office app. Record the error and the time of the attempt.
Have an administrator open the Microsoft Entra admin center and go to Identity > Monitoring & health > Sign-in logs. Filter by the affected user and the time of the failure.
Open the failed sign-in and select the Conditional Access tab. Review the policies and their results, including any device compliance or client application requirements.
In Sign-in logs, compare the failed Office sign-in with the successful browser sign-in. Check the application, client app, device information, and Conditional Access results for differences.
Ask the administrator to resolve the specific unmet requirement or review the policy for the RDP scenario under the organization's security rules. Retry opening the file in the Office app.

Check the RDP environment against device and app requirements
Use this check when the sign-in log identifies device management, compliance, or client application requirements.
Work with Office files in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move existing documents into a new workflow. It does not bypass Microsoft Entra or SharePoint access policies.

Frequently Asked Questions
Why can I open SharePoint in Edge but not an Excel file in the desktop app?
The browser and desktop app may have different sign-in details or Conditional Access requirements. An administrator can compare both attempts in Microsoft Entra admin center under Identity > Monitoring & health > Sign-in logs.
Where can an administrator see which policy blocked the sign-in?
In Microsoft Entra admin center, go to Identity > Monitoring & health > Sign-in logs, open the failed sign-in, and select the Conditional Access tab to review policy results.
What if Access work or school is missing from the RDP server settings?
Ask the administrator to check the failed sign-in's device information and determine the supported management approach for the remote environment. The missing Settings option does not by itself identify the cause.
Will WPS Office bypass a SharePoint Conditional Access block?
No. Microsoft Entra and SharePoint policies still control access. WPS Office can work with an authorized local copy if your organization's rules allow it.




