Re: very large excel files

Hi Peder and everyone I have found that using Pivot tables adds a huge amount to the file size. Each table you make increases the resultant file size, and I think it depends on the complexity of the pivot table you do. There is a work around on a very helpful site (exceltips) for excel that

Re: very large excel files

Chris, You may find that files are growing in size over time. This happens when you 'Save' the file. Each Save adds any changes you have made to the original file, hence it will grow over time. This is very noticeable in Powerpoint files were you may have added or modified images, etc. Th

very large excel files

Hi people While doing some validation of a small data file in excel this arvo (original size about 200k) I now have a file over 30mb! I have 4 pages, two with about 400 records long containing text and numbers and out to ab in width. I have two other pages that I have done a few pivot tab