file using pivot tables is too large

B

brad333

I use Excel 2007. I have one file that is very large (about 50mb) with sales
data. I then have another file with about 15 pivot tables using the sales
data. The file with the pivot tables was 6mb and recently went to 13mb and i
am not sure why? I have tried to compress the file but it only went from
13mb to 12.5 mb. Is there any way to link the data source of all the pivot
tables so the file size is smaller?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top