Do not cache network files locally

This policy setting allows you to configure whether network files are locally cached when editing spreadsheets stored on network shares.

If you enable this policy setting, a file located on a network share may not be saved if the network connection was lost at any time while editing the file and the file contains a pivot table, VBE code or an embedded OLE object.

If you disable or do not configure this policy setting, network files are locally cached when editing spreadsheets stored on network shares. This may help prevent data loss during network failures.

Supported on: At least Windows 7

Registry HiveHKEY_CURRENT_USER
Registry Pathsoftware\policies\microsoft\office\16.0\excel\options
Value Namenetworkresiliency
Value TypeREG_DWORD
Enabled Value0
Disabled Value1

excel16.admx

Administrative Templates (Computers)

Administrative Templates (Users)