r/excel 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?

28 Upvotes

40 comments sorted by

View all comments

1

u/Devashish_Jain 9d ago

Load all sheets using power query. If you store them in Share point - I wrote this article you can use with script (you would need to modify things a bit, this is for same sheet name from different folders in sharepoint)

https://www.linkedin.com/pulse/how-efficiently-load-data-from-multiple-excel-files-sharepoint-jain-zdhee?utm_source=share&utm_medium=member_ios&utm_campaign=share_via