Home

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

Ghis71
Visitor

Hi,

 

     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?

 

Thanks

 

 

 

 

 

 

 

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