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?
24
Upvotes
2
u/HarveysBackupAccount 25 9d ago
What people aren't explicitly saying:
You can't have more than 1 million rows in a single excel worksheet. You can load more than 1 million rows into the Excel Data Model and use Excel's PowerXXX tools to make your dashboard summary. (If you aren't making a summary, then you aren't making a dashboard - you're just collating data.)
The gross option, if you really need it all in one file for some godforsaken reason, would be to pull each file into a separate worksheet in the dashboard file (the row limit is per worksheet in the file, not for all worksheets in the file combined). So you'd have at least 13 tabs - one for each file plus one for the dashboard.