2Qs on large data excel dump

[questforexcel]

Hi All,

I have 2 questions on working around large data dumps in excel.

First - how to reduce the file size? My file is a data dump of about 200K records. The original file size was 100MB managed to reduce it to 50MB by saving it in Binary format.

Is there any possibility to reduce the file size further? The file only has pivots.

Second - When working across a large data dump is there a more efficient way to work around the pivot table Values field. I.e. Every time i click on a figure on the value field, is it possible to only highlight and show that column figures and corresponding details rather than pulling out every detail of all other columns.

In simple terms - is there a better way to analyse details of a summary pivot table based on large data dumps

Thanks

 

[GraH]

Hi,

In the pivot data settings you can play a bit with these settings:

Without saving the source data with file, the pivot cache is cleared. This also means slicers, show detail, filtering do no longer work. If that's needed, the refresh data on opening will restore the cache. Consider the refresh time.

Not sure about your second question what you mean. Maybe slicers are an option? Or moving on to Power Pivot to enable drill down. But that all together is a different story.