Managing Large Datasets

[jeffd1]

First time posting on this forum but have been using Excel for years.

I have a excel file that is quite large, maxing out the 1,048,576 rows, across several sheets. I originally tried separating them to different workbooks to ease up the lag time but it would take even longer if I needed something from each file.

My question may actually be out of my comfort zone with Excel. But what would you recommend to handle a database of this size, that won't take 10 minutes to load and lag/"no response" from simple excel functions? I am running on Office 2016.

Thanks!

 

[63falcondude]

Access. Excel is not meant to be used as a database.

 

[jeffd1]

I figured as much. I walked into this mess with a client and I knew this couldn't possibly be a good solution in the long-run. Thank you!