If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Managing File Size in Excel 2007
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. |
#2
|
|||
|
|||
Managing File Size in Excel 2007
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "CJInc" wrote in message ... 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. |
#3
|
|||
|
|||
Managing File Size in Excel 2007
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). "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "CJInc" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|