Hi There,


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.


Thanks