Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 File Size | Excel Discussion (Misc queries) | |||
Excel 2007 - managing Styles | Excel Discussion (Misc queries) | |||
How to reduce file size when converting to pdf for excel 2007? | Excel Discussion (Misc queries) | |||
Excel 2007 export file size huge | Excel Discussion (Misc queries) | |||
How reduce the file size of Excel 2007 files (wasted non value spa | Excel Discussion (Misc queries) |