Excel File Huge with no data
 

I have a User that setup a new Excel 2007 file with 13 tabes in it of which
12 are copies of the same sheet over and over, each sheet just has a simple
set of 50 rows and 30 columes for data entry to be filled in each month with
a total at the end of the rows, the finial sheet is a summory of the other
12 sheets. There is no datat in any of the sheets yet, but the file is
already 30mb in size. This file is reated in Excel 2007 and saves in the
..Xlsx format.

Excel File Huge with no data
 

See this pag Tim
http://www.contextures.com/xlfaqApp.html#Unused
I think your usedrange is to big on each sheet


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tim Boudin" wrote in message ...
I have a User that setup a new Excel 2007 file with 13 tabes in it of which
12 are copies of the same sheet over and over, each sheet just has a simple
set of 50 rows and 30 columes for data entry to be filled in each month with
a total at the end of the rows, the finial sheet is a summory of the other
12 sheets. There is no datat in any of the sheets yet, but the file is
already 30mb in size. This file is reated in Excel 2007 and saves in the
.Xlsx format.

Excel File Huge with no data
 

Yes, that was the problem, I went through all of the sheets and one of them
must have has something way down in the rows, once I deledted the unused
area the size wend down to a normal size of 2k. Thank for the help.

"Ron de Bruin" wrote:

See this pag Tim
http://www.contextures.com/xlfaqApp.html#Unused
I think your usedrange is to big on each sheet


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tim Boudin" wrote in message ...
I have a User that setup a new Excel 2007 file with 13 tabes in it of which
12 are copies of the same sheet over and over, each sheet just has a simple
set of 50 rows and 30 columes for data entry to be filled in each month with
a total at the end of the rows, the finial sheet is a summory of the other
12 sheets. There is no datat in any of the sheets yet, but the file is
already 30mb in size. This file is reated in Excel 2007 and saves in the
.Xlsx format.