A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Thank you for the detailed post, the environment information, reproduction steps, and what you’ve already ruled out make this much easier to narrow down.
Based on your description, I understand that on Windows Server 2022, Excel re-prompts “Enable Editing” every time the same .xls file is reopened, while on Windows 11 with the identical Microsoft 365 Apps build the trust decision is remembered permanently, and you suspect the Trusted Documents feature is being disabled by policy on the server.
-Is behavior expected to differ between Server 2022 and Windows 10/11?
No. Trusted Documents behavior in Microsoft 365 Apps is identical across supported client and server operating systems. There is no built-in, by-design difference on Windows Server 2022. When you click Enable Editing, Excel writes a per-file trust record under:
HKCU\Software\Microsoft\Office\16.0\Common\Trusted Documents\TrustRecords
If reopening the same file prompts again, either the trust record is not being written (blocked by policy), or it is being discarded (profile/registry not persisting). Since your issue reproduces within the same session, a policy is the most likely cause, your suspicion is well-founded.
1.The exact policy paths to check
Please verify all of the following, as any one of them produces your symptom:
-Turn off trusted documents — Registry: HKCU\Software\Policies\Microsoft\Office\16.0\excel\security\trusted documents > DisableTrustedDocuments = 1. GPO path: User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > Security > Trust Center > Trusted Documents > “Turn off trusted documents”. This must be Not Configured or Disabled for trust to be remembered.
-Turn off trusted documents on the network, same key, value DisableNetworkTrustedDocuments = 1, same GPO folder. Important: if the .xls files are opened from a mapped drive, UNC path, or DFS share on the server, this policy alone reproduces your exact behavior while local files work fine. The Microsoft Security Baseline for Microsoft 365 Apps for enterprise enables this setting by default, so if a baseline was imported on the server, this is a very likely culprit.
-Also check the same two values under the Office-wide hive: HKCU\Software\Policies\Microsoft\Office\16.0\common\security\trusted documents.
To confirm which GPO is delivering the value, run gpresult /h report.html under the affected user account and search the report for “Trusted Documents”, or use rsop.msc. If the value exists in the registry but no GPO appears in the report, it was likely set directly by a hardening script or imported baseline (LGPO.exe), in which case check Local Group Policy on the server itself.
2.Server-specific caveats before re-enabling
-Security baselines such as the Microsoft 365 Apps security baseline, CIS benchmarks, and DISA STIGs commonly disable Trusted Documents (especially on the network) as intentional hardening. Please confirm with your security team before overriding, and prefer scoping the change (e.g., a separate GPO/OU for the server, or keep network trust disabled but allow local trust).
-On RDS / multi-session hosts, trust records live in HKCU, so mandatory profiles, profile resets, or FSLogix/UPD misconfiguration will silently discard trust between logons. That would cause re-prompting across sessions rather than within one, so it’s a secondary check in your case.
-A cleaner long-term alternative: add the folder containing these legacy .xls files as a Trusted Location (Excel > Trust Center > Trusted Locations, or the equivalent policy). Files in a Trusted Location bypass Protected View entirely and don’t depend on per-file trust records at all.
Quick verification once you make the change: open the .xls, click Enable Editing, then check whether a new entry for that file path appears under the TrustRecords key above. If the record appears and persists, reopening will no longer prompt.
Please let me know what gpresult shows, happy to help trace the source GPO if the value turns out to come from somewhere unexpected.