Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 export file size huge | Excel Discussion (Misc queries) | |||
i need to import a huge txt file into excel | Excel Discussion (Misc queries) | |||
How to Reduce the Excel File Size? & Make it work with huge data | Excel Discussion (Misc queries) | |||
deleted bitmaps and still have huge excel file size | Excel Discussion (Misc queries) | |||
huge huge excel file... why? | Excel Discussion (Misc queries) |