Excel Overload

raskinsm

New Member
Joined
Feb 10, 2020
Messages
2
Office Version
365
Platform
Windows
Hello,

I have a large spreadsheet which has 847K records (rows) and 30 columns. I need to work with this spreadsheet sorting, running macros and formulas. When I filter and sort, it will run for 5- 6 hours then crash. I have seen larger data sets work before (at another company), this should be doable. Presently, the sheet is clean with no formulas etc.

I am running a Intel Core i5 vPro 8th Gen
32 Gig of RAM
Office 64 Bit

I have tried breaking the report apart and this just won't work. I have made multiple attempts here.

Any recommendations, other than breaking the report apart, would be greatly appreciated.

Thanks
Marc
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
9,955
Office Version
2019, 2016, 2013
Platform
Windows
maybe Power BI Desktop, and us that to query the data file ? I'm just starting out to learn this
 

raskinsm

New Member
Joined
Feb 10, 2020
Messages
2
Office Version
365
Platform
Windows
maybe Power BI Desktop, and us that to query the data file ? I'm just starting out to learn this
I will look into BI Desktop. I will try it out and see if it can manipulate the data more efficiently. Thanks
 

Forum statistics

Threads
1,085,747
Messages
5,385,651
Members
401,964
Latest member
Broccolikid

Some videos you may like

This Week's Hot Topics

Top