Massive Data Table - Minimize File Size

[London78000]

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

[sandy666]

use Power Query (from file or from folder) then you can use as table or as Pivot, Power Query works with something like "links" to the external data, it doesn't copy data to the target file

[London78000]

use Power Query (from file or from folder) then you can use as table or as Pivot, Power Query works with something like "links" to the external data, it doesn't copy data to the target file

Hi Sandy,

I am not sure to know how to do this. Would you have any videos ? Will the size be heavy?

[sandy666]

the size depends on the amount of data but rather it won't be heavy, to see heavy effect you'll need a few millions of rows

Import data from a folder with multiple files

Import data from data sources

if you want to know more see this: Learn Power Query