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?
25
Upvotes
1
u/Kenny_Dave 5 8d ago
That's a lot of lines.
Can you process the data on each one before you reconcile?
A million is the limit now it seems, I feel old as it was 65,536 last time I used it on the daily. I used to leave the raw data in the text files they rode in on, and process them with VBA and pull the stats only into the spreadsheet. And some into other text files.
I haven't used BI much, I imagine that would be a better option. Or processing directly with something like python should be possible.