Managing File Size in Excel 2007

[CJInc]

I recently moved to Excel 2007 from 2003. I created a data entry workbook
for a survey I'm doing for a client. The workbook contains 6 protected
sheets -- a sheet for respondent information and sheets to enter data for 5
plant sites -- and 4 hidden sheets that I use to capture the data in tabular
form for ease of analysis. I would expect the size of a similar instrument
in Excel 2003 to be about 1M -- it's an order of magnitude larger in Excel
2007. That is a real problem: I distribute the surveys by E-mail, and most
of my clients' firewalls block files that large. And as surveys go, this is
a short one for me. Each form is only 3 printed pages (landscape
orientation), and I have done some surveys that are 3 - 5 times longer than
that.

Does anyone have any tips for minimizing the size of Excel 2007 workbooks?

Thanks in advance for any help you can offer.

 

[Ron de Bruin]

Hi

Excel 2007 workbooks will be smaller
I think your usedrange is not correct

See Debra's site for more info
http://www.contextures.com/xlfaqApp.html#Unused

 

[CJInc]

Thanks for your help. Your suggestion helped me identify a problem with a
couple of the hidden worksheets that I'm using to tabulate responses. I
redid those worksheets and the file size dropped dramatically (to about 150
kb).