Excel Window Freezes randomly?

Jfreshh330

New Member
Joined
Apr 1, 2018
Messages
3
Hello, I have Microsoft Excel 2016 Installed on my Dell PC on Windows 10. I have a few .xlsb spreadsheets that are quite large that I work on almost daily. Every day at random, the window will freeze, so when I hover my cursor over a corner of the window so I can resize it, normally, the minimize, full screen, and close toolbar buttons at the top right, will resize along with the window. However, the window seems to freeze, and I can resize the window, but when I click on or in a cell, the window stays frozen. I have attached a few screenshots. I have already disabled all add-ins in case that was the issue. I have tried Quick Repair and Online Repair from Control Panel, and have rebooted my pc countless times. Any advice?
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
57,510
Office Version
  1. 365
Platform
  1. Windows
A bit more information would probably be helpful.

Are these the only Excel files that you have issue with?

How large is "large"?
What is the size of the file?
How many sheets/rows/columns?

Does the file contain VBA code?
If so, is any of it event procedure VBA code?

Does the file contain any links or formulas that link to thinks outside of that particular workbook?
 

Jfreshh330

New Member
Joined
Apr 1, 2018
Messages
3
A bit more information would probably be helpful.

Are these the only Excel files that you have issue with?

How large is "large"?
What is the size of the file?
How many sheets/rows/columns?

Does the file contain VBA code?
If so, is any of it event procedure VBA code?

Does the file contain any links or formulas that link to thinks outside of that particular workbook?
No, any excel file I open, this seems to happen after it’s been open a while. At least an hour or so.

The xlsb file is about 8mb

Around 25 sheets, most with thousands of rows and anywhere from 3-15 columns. Multiple pivot tables.

No VBA Code, the file does contain links & formulas to an outside workbook.
 

bilal_aoun

New Member
Joined
May 3, 2021
Messages
25
Office Version
  1. 2016
Platform
  1. Windows
Are using 32 or 64 bits?
Mine was giving me issues with the 32 bit , all is well with the 64bits
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
57,510
Office Version
  1. 365
Platform
  1. Windows
No, any excel file I open, this seems to happen after it’s been open a while. At least an hour or so.
If it truly happens on all Excel files, regardless of the size, then that sounds to me like a system issue.
Could be problems with your PC, or your installation of Excel.
You could try re-installing Excel, and making sure all updates have been applied.
If that does not work, you may want to have an IT expert check out your system.
 

Watch MrExcel Video

Forum statistics

Threads
1,132,702
Messages
5,654,820
Members
418,155
Latest member
demasisi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top