Problem
I've run into the following issue when opening an Excel
file from a local area network drive (provided by my Synology NAS) - whenever I open the file, it is opened as write protected
(schreibgeschützt in German).
Attributes
Looking at the file's attributes, it is clearly visible that the file is not write protected:
I can also save the file on the same network drive under a new name without any problems. When I open that new copy of the file, same behaviour as above.
Registry Key
I also know about some issues with older versions of Office that suggest creating a new registry key DisableRobustifiedUNC
under HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
and setting it to 1
. As I'm using Office 2019, there's no such registry path (and still trying to set it under the 2016 path doesn't change anything).
Excel Trust Center
Next thing I tried was to add the network drive in Excel under the "trusted locations" (if that's the correct term for an English Excel):
Unfortunately, same behaviour as before.
Lastly I tried - also in the Trust Center options - to completely uncheck all the settings under "protected view" (only as a temporary measure):
As before, and you may have guessed it, no change at all.
What's wrong here? How can I get Excel to open my own Excel file from my own network drive without the protected view?