Using Excel pivot table cache to reduce the file size of Excel workbook

Excel workbook with pivot table is a common way to analyze data. But sometimes the workbook size will get too big especially when you have 100K and above rows of data. Using the cache in pivot table, we can reduce the file size by more than half. But to take note this is only good and safe for static data which does not change. See the Youtube video below for the hack.