I have an excel template that I am using to collect data. I have protected
the sheet to keep people from editing it. I have also used a lot of
formating, and am using if statements. I have also been hiding rows to keep
people from leaving the work area. and put my wor areas at the extreme edges
of the worksheets. My file is made up of a dozen sheets. Until I started
protecting the sheets, the file was less than 1 MG althought I have also
added a couple of worksheets to the spreadsheet. When I zip the file, it
compresses from 15meg to 1meg. What is causing the exponential growth in the
spreadsheet and how can I reduce the size of the file?