Lastly I tried - also in the Trust Center options - to completely uncheck all the settings under "protected view" (only as a temporary measure):Īs before, and you may have guessed it, no change at all. 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): 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). Click Protected View and unmark the option for Enable Protected. Excel file does not open, Its stuck indefinitely in opening in protected view stage 1. Enable Protected View for files originating from. Untick the checkbox appropriate for your situation: Enable Protected View for files originating from the Internet. Then go to Options and select Trust Center. 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. Disable Protected View Launch Excel and click on the File tab. txt would open notepad) xlsx file extension not valid Verified 3 days agoExcel HYPERLINK function not. When I open that new copy of the file, same behaviour as above. Fix 5 Remove Password From Protected Excel Sheet. In the Options dialog, click Trust Center > Trust Center Settings. I can also save the file on the same network drive under a new name without any problems. Open Excel, and click File or the Office button > Options. Looking at the file's attributes, it is clearly visible that the file is not write protected: 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).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |