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