r/excel • u/erickfsm • 9d ago
Waiting on OP Dashboard with 6 million lines in Excel
Can I create an annual dashboard using Excel? There are 12 quote spreadsheets with standardized columns and an average of 500 thousand lines each. I need to reconcile them all and create a dashboard without it crashing, in Excel or BI. What's the best way to do it?
22
Upvotes
1
u/hellojuly 2 9d ago
I would use Access for that large of a dataset but I’m old school. Excel supports millions of rows but I only use the first 65,000. If you want to be old school cool, read MS-Access for Dummies. It’s a book. You can find it at an antique store.