If you are using Excel for the Macintosh click here. If you are using Excel 2003 or a prior version of Excel click here. We now explain how to download and install the Real Statistics Resource Pack for use with Excel 2010, 2013, 2016, 2019, 2021 or 365 on Windows. These complement the standard Excel capabilities and make it easier for you to perform the statistical analyses described in the rest of this website. 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.The Real Statistics Resource Pack contains a variety of supplemental functions and data analysis tools not provided by Excel. 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). 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. When I open that new copy of the file, same behaviour as above. I can also save the file on the same network drive under a new name without any problems.
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 kommentar(er)
