Unable to open .xls that have protected sheets or protect workbook structure




     Since last week, I am no longer able to open .xls files that have protected sheets or workbook structure.  Before that everything was working well.  I can open those excel files on other computers with the same version of excel.   Excel 2016 Version 1901 (build 11231.20130)


I have try the following things:


- quick Repair

- Online Repair

- Ignore other application that use Dynamic Data Exchange (DDE)

- removed all add-ins and Com

- enable Macro

- remove the 3 check box of the Protected View screen

- Remove the file block settings

- Uninstall office completely from the computer with the Microsoft fix-it program and did a fresh re-install

- Deleted the user profile from the computer and even try with a different user.

- can open other .xls file that does not contain protect functionality in it.

- I tried to open the file from the network or locally on my computer.


When I open the problematic workbook, it freeze completely with CPU at 30% and memory at 3.2 gig and go up to 3.6 gig before closing.  I have 16 gig of ram on my computer.  If I open Excel then I open the file, I get a grey background with the menu and formula bar.  the I click in the grey area and I get  a message saying "Not enough system resources to display completely"


Anybody as seen that and know the fix?










Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies