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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Forum statistics

Threads
1,224,823
Messages
6,181,182
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

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