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.
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.