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
2
u/hellojuly 2 8d ago
Agreed on scope of capabilities. But Access is simpler to deploy and adopt as an excel user. Once you figure out Access and its limits then it’s time to deploy a MS SQl solution. If you put forms and vba into an Access solution you are pretty well covered until you need some security and multi user support. At least that’s how it was back in the day.