Home

Excel User Interface (UI) Freezing

%3CLINGO-SUB%20id%3D%22lingo-sub-482536%22%20slang%3D%22en-US%22%3EExcel%20User%20Interface%20(UI)%20Freezing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482536%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Excel%20Community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20reaching%20out%20because%20I%20have%20encountered%20an%20issue%20with%20an%20excel%20file%20and%20require%20some%20support%20on%20how%20to%20fix%20and%20resolve%20this%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20I%20am%20having%20is%20that%20the%20Excel%20user%20interface%20appears%20to%20be%20frozen%20for%20a%20specific%20Macro%20Enabled%20Worksheet%20(.xlsm).%20The%20file%20opens%20okay%2C%20but%20upon%20opening%2C%20everything%20is%20frozen%20including%20all%20excel%20options%20and%20buttons.%20The%20keyboard%20shortcuts%20do%20not%20appear%20to%20be%20working%20either.%20The%20file%20is%206.93%20MB%20with%20a%20reasonable%20amount%20of%20conditional%20formatting%20%2F%20graphics%20content%20and%20macros.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20read%20a%20few%20previous%20forum%20posts%20and%20it%20seems%20that%20I%20am%20not%20the%20only%20one%20to%20encounter%20this%20type%20of%20problem.%20Based%20on%20reading%20other%20people%E2%80%99s%20solutions%2C%20I%20have%20tried%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3ERunning%20excel%20in%20safe%20mode%3C%2FLI%3E%3CLI%3EDisabling%20all%20Excel%20Add-ins%20through%20options%3C%2FLI%3E%3CLI%3EDisabling%20all%20COM%20Add-ins%20through%20Options%3C%2FLI%3E%3CLI%3EDisabling%20macros%20through%20Options%3C%2FLI%3E%3CLI%3EInstalling%20Office%20updates%3C%2FLI%3E%3CLI%3ERepairing%20Office%3C%2FLI%3E%3CLI%3EUsing%20the%20Excel%20%E2%80%9COpen%20and%20Repair%E2%80%A6%E2%80%9D%20option%3C%2FLI%3E%3C%2FOL%3E%3CP%3EUnfortunately%2C%20none%20of%20these%20actions%20have%20been%20successful%20in%20resolving%20the%20problem.%3C%2FP%3E%3CP%3EI%20would%20greatly%20appreciate%20suggestions%20and%20help%20on%20how%20to%20resolve%20this%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20Thanks%2C%26nbsp%3B%3C%2FP%3E%3CP%3EStuart%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3EP.S%26nbsp%3BHere%20is%20some%20background%20information%20on%20the%20specification%20of%20my%20PC%20and%20Office%20%2F%20Excel%20Version%3A%20%3C%2FU%3E%3C%2FP%3E%3CP%3EOperating%20System%3A%20Windows%2010%20Pro%3C%2FP%3E%3CP%3EProcessor%3A%20Intel(R)%20Core(TM)%20i3-7100U%20CPU%20%40%202.40GHz%2C%202400%20Mhz%2C%202%20Core(s)%2C%204%20Logical%20Processor(s)%3C%2FP%3E%3CP%3ESystem%20Type%3A%20x64-based%20PC%3C%2FP%3E%3CP%3EInstalled%20Physical%20Memory%20(RAM)%3A%208.00%20GB%3C%2FP%3E%3CP%3EExcel%3A%20Microsoft%20Office%20365%20Subscription%20%2F%2032-bit%3C%2FP%3E%3CP%3EExcel%20Version%3A%201903%20%2F%20Build%2011425.20244%20%2F%20Click-to-Run%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-482536%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDisplay%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFreezing%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFrozen%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Interface%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-482605%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20User%20Interface%20(UI)%20Freezing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482605%22%20slang%3D%22en-US%22%3EWhat%20happens%20if%20you%20try%20this%20at%20the%20end%20of%20your%20working%20day%2C%20open%20the%20file%20and%20then%20leave%20your%20PC%20working%20at%20it%20overnight%3F%20Does%20Excel%20come%20to%20life%20if%20you%20wait%20long%20enough%3F%20If%20you%20have%20access%20to%20someone%20with%20a%20different%20version%20of%20Excel%2C%20try%20if%20the%20file%20can%20be%20opened%20with%20that%20version.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-484721%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20User%20Interface%20(UI)%20Freezing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-484721%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3Bthank%20you%20for%20your%20suggestion%2C%20it%20is%20appreciated.%20I%20have%20tried%20both%20but%20unfortunately%20neither%20appears%20to%20have%20resolved%20the%20problem.%20The%20file%20did%20suddenly%20spring%20into%20life%20yesterday%20for%2030%20minutes%20when%20opening%20a%20PowerPoint%20presentation%20with%20links%20to%20the%20file%2C%20but%20subsequently%20froze%20again%20and%20still%20not%20working%20%3A%2F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-485915%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20User%20Interface%20(UI)%20Freezing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-485915%22%20slang%3D%22en-US%22%3EI'm%20afraid%20I'm%20out%20of%20ideas%20%3A-(%3C%2FLINGO-BODY%3E
Stuart-Signify
New Contributor

Hello Excel Community,

 

I am reaching out because I have encountered an issue with an excel file and require some support on how to fix and resolve this problem.

 

The problem I am having is that the Excel user interface appears to be frozen for a specific Macro Enabled Worksheet (.xlsm). The file opens okay, but upon opening, everything is frozen including all excel options and buttons. The keyboard shortcuts do not appear to be working either. The file is 6.93 MB with a reasonable amount of conditional formatting / graphics content and macros.

 

I have read a few previous forum posts and it seems that I am not the only one to encounter this type of problem. Based on reading other people’s solutions, I have tried the following:

 

  1. Running excel in safe mode
  2. Disabling all Excel Add-ins through options
  3. Disabling all COM Add-ins through Options
  4. Disabling macros through Options
  5. Installing Office updates
  6. Repairing Office
  7. Using the Excel “Open and Repair…” option

Unfortunately, none of these actions have been successful in resolving the problem.

I would greatly appreciate suggestions and help on how to resolve this issue.

 

Many Thanks, 

Stuart

 

P.S Here is some background information on the specification of my PC and Office / Excel Version:

Operating System: Windows 10 Pro

Processor: Intel(R) Core(TM) i3-7100U CPU @ 2.40GHz, 2400 Mhz, 2 Core(s), 4 Logical Processor(s)

System Type: x64-based PC

Installed Physical Memory (RAM): 8.00 GB

Excel: Microsoft Office 365 Subscription / 32-bit

Excel Version: 1903 / Build 11425.20244 / Click-to-Run

3 Replies
What happens if you try this at the end of your working day, open the file and then leave your PC working at it overnight? Does Excel come to life if you wait long enough? If you have access to someone with a different version of Excel, try if the file can be opened with that version.

Hi @Jan Karel Pieterse thank you for your suggestion, it is appreciated. I have tried both but unfortunately neither appears to have resolved the problem. The file did suddenly spring into life yesterday for 30 minutes when opening a PowerPoint presentation with links to the file, but subsequently froze again and still not working :/ 

I'm afraid I'm out of ideas :-(
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies