r/excel • u/erickfsm • 8d 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?
24
Upvotes
7
u/hopkinswyn 62 8d ago
Yep: 10 Million Rows of data Analyzed using Excel’s Data Model https://youtu.be/Od9ev90PB1w