Office 365 Excel slower than Excel 2010?

EdStockton

New Member
Joined
Aug 6, 2014
Messages
47
I am working with General Ledger reports that come with lots of empty rows and rows with irrelevant data. Some of theses worksheets are around 350,000 rows. When I eliminate the unnecessary data the rows remaining are usually around 200,000. I am running Microsoft Office 365 Excel. My computer is a Dell XPS 15-7590 with an Intel Core i9-9980HK @ 2.40 GHz and 64 GB of Ram. It usually requires around 2 to 3 hours to delete the unneeded rows. Today, I used a different computer. It was an HP ZBook with an i7 Intel Core @ 2.80 GHz with 8 GB of Ram. It was using Excel 2010. That machine got the job done in only 10 minutes.

Could my settings be a problem or are there differences between Office 365 and Excel 2010 that could be the cause. Someone said it may be because of the more comprehensive Undo function of Office 365?

I would like to speed this process up.

Thanks for any suggestions.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,215,729
Messages
6,126,525
Members
449,316
Latest member
sravya

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