Optimize Excel for Faster Data Analysis
Hi, my Excel has about 300,000 rows, 37 "raw" data columns (so no formulae) and another 32 columns, each with a formula. On a high spec Max with lots of memory, Excel 365 takes about 90 seconds to open... (Budget: £250 - £750 GBP, Jobs: Data Processing, Excel, Microsoft Office, Visual Basic)
Hi, my Excel has about 300,000 rows, 37 "raw" data columns (so no formulae) and another 32 columns, each with a formula. On a high spec Max with lots of memory, Excel 365 takes about 90 seconds to open... (Budget: £250 - £750 GBP, Jobs: Data Processing, Excel, Microsoft Office, Visual Basic)
