Excel Protected View says files on network drive are on Internet; must enable editing
Posted on 2011-03-03
We have recently upgraded to Excel 2010. One of the new "features" is Excel Protected View. A problem we are encountering is when using UNC file shares that are numeric or have a FQDN, Excel believes that file is "on the Internet." Does anyone have any information on how to tell Excel that a particular IP address or FQDN is local and not to mark it as protected?
\\10.0.0.15\shares (causes Excel to use Protected View -- file from Internet)
\\nas1\shares (causes Excel to NOT use Protected View)
\\nas1.abcompany.local\shares (causes Excel to use Protected View -- file from Internet)
Obviously nas1 and nas1.abcompany.local both resolve to 10.0.0.15.