Massive Data Table - File Size

  • 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.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!