| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Size
Hi:
I have a file that went from 100KB to 8MB. I only added a few rows to it. Does anyone have any idea what would cause it or how to find out? I did not add any pictures to the file. Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File Size
Have a read at Debra Dalgleish's site.
http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Mon, 23 Oct 2006 09:19:01 -0700, Ldyflyr wrote: Hi: I have a file that went from 100KB to 8MB. I only added a few rows to it. Does anyone have any idea what would cause it or how to find out? I did not add any pictures to the file. Thanks, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
File Size
You need to reset the used range (as a guess). Take a look at the scroll
bars. Chances are you can scroll well past the end of the populated data (probably to 65,536)... check out this link to reset the used range... http://www.contextures.com/xlfaqApp.html#Unused -- HTH... Jim Thomlinson "Ldyflyr" wrote: Hi: I have a file that went from 100KB to 8MB. I only added a few rows to it. Does anyone have any idea what would cause it or how to find out? I did not add any pictures to the file. Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reducing 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 too big after converting Lotus 1-2-3 to Excel | Excel Discussion (Misc queries) | |||
| Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
| excel file size bloat | Excel Discussion (Misc queries) | |||
Linear Mode
