as of this month Excel 97 type files open in Protection Mode

%3CLINGO-SUB%20id%3D%22lingo-sub-1708593%22%20slang%3D%22en-US%22%3Eas%20of%20this%20month%20Excel%2097%20type%20files%20open%20in%20Protection%20Mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1708593%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3Ei%20have%20an%20issue%20with%20opening%20Excel%2097%20xls%20files%2C%20they%20now%20suddenly%20open%20in%20%22protection%20mode%22%20This%20is%20happening%20after%20August%2031%202020.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Emessage%3B%20PROTECTED%20VIEW%26nbsp%3Boffice%20has%20detected%20a%20problem%20with%20this%20file%20Editing%20may%20harm%20your%20computer%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20get%20this%20message%20opening%20the%20file%20either%20from%20the%20office%20network%20drive%20AND%20from%20my%20local%20c%3A%20drive.%20Note%20that%20I%20did%20not%20have%20this%20issue%20until%20August%2031st%20when%20I%20last%20ran%20the%20Macro%20that%20opens%20these%20files%20and%20processes%20its%20contents%20to%20another%20workbook.%20also%20Note%20that%20the%20files%20from%20August%2C%20that%20opened%20with%20no%20issues%20in%20August%20now%20also%20open%20with%20this%20%22error%20message%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Ethis%20only%20applies%20to%20only%20applies%20to%20*.xls%20file%20types%20i.e.%20Excel%2097%20format%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1708593%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

i have an issue with opening Excel 97 xls files, they now suddenly open in "protection mode" This is happening after August 31 2020.

message; PROTECTED VIEW office has detected a problem with this file Editing may harm your computer

 

I get this message opening the file either from the office network drive AND from my local c: drive. Note that I did not have this issue until August 31st when I last ran the Macro that opens these files and processes its contents to another workbook. also Note that the files from August, that opened with no issues in August now also open with this "error message"

this only applies to only applies to *.xls file types i.e. Excel 97 format

 

0 Replies