Excel cannot handle large data = company settings?

Happydays886

New Member
Joined
Mar 31, 2021
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Hello,

Longtime excel user here. I am getting increasingly annoyed with Excel freezing / glitching, and I have ruled out majority of issues besides what I cannot see/control.

In perspective, using any worksheet with >25,000 rows of data, excel is incredibly slow. Currently, a sheet with 100k lines, deleting maybe 50,000 lines on a filter, and the entire computer is basically frozen at +20min.

This is unheard of to me. I've had +100mb excel files at previous employers (16g ram / 64bit excel) and it would be "slow", but not like this.

Has anyone experienced something like this before, where the employer has a software / plug-in that causes excel to behave the way I am describing?

TDLR, excel behaves a lot slower at one employer vs previous employers. Computer is 16g ram / i9 processor.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Is it the same in safe mode?
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

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
Back
Top