I have various massive files that I am downloading on a monthly basis (maybe 5 or 6). I started created data table in my consolidation workbook where I will create dashboards.
The issue is that the size of the file gets enormous. I heard on Youtube that it is better to create pivot tables using the "external sources" option. I tried that option but the size is still the same.
I wanted to have your opinion on how to create dashboards based on huge data tables? The idea is to have minimize as possible the size of my consolidation workbook.
P.S: In this workbook, I will just use sumifs, vlookups formulas based on several conditions.