| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Size
I have an Excel 2003 file which was about 2MB in size running various array
formulae across a range of data. Having recently added one more sheet with formulae that are actually less complex than the other 10 or so sheets, the file size has increased to 7MB. Why would it do this and how can I get the file size back down closer to 2MB again?! Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File Size
You might have unused lines in each of the worksheets that have been
previously formatted but are not in use. The following URL has information on removing unused lines from the worksheets in a workbook. There's a manual version and a macro driven version. http://www.contextures.com/xlfaqApp.html#Unused -- Kevin Backmann "JMW" wrote: I have an Excel 2003 file which was about 2MB in size running various array formulae across a range of data. Having recently added one more sheet with formulae that are actually less complex than the other 10 or so sheets, the file size has increased to 7MB. Why would it do this and how can I get the file size back down closer to 2MB again?! Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unusual File Size in Excel file | Excel Discussion (Misc queries) | |||
| how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
| Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
| File size - | Excel Discussion (Misc queries) | |||
| WHY IS MY FILE SO BIG? How can I reduce the size of a file? I h. | Excel Discussion (Misc queries) | |||
Linear Mode
