View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] sephiroths816@gmail.com is offline
external usenet poster
 
Posts: 22
Default How can I shrink a file size w/ a pivot table and many formulas?

I'm not sure if it will help you, but it definitely helped me. I found
a program that shrinks Excel file sizes. The reasoning they gave was
that for some reason while creating a sheet, it redundantly saves
formulas and data that you previously deleted or something. Anyhow, I
went from a 10mb file to a 3mb file. Then i shrunk it again to see if
it would shrink again. It went to 600k. I couldn't shrink it anymore
then that. I don't quite remember the name of the program, but if you
google "Excel file shrink" or something like that, you're bound to
find it or something similar.

Is there something that I can do to the front end of the file w/o using vb
code?