ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   File Size (https://www.excelbanter.com/excel-discussion-misc-queries/115627-file-size.html)

Ldyflyr

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,

Gord Dibben

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,



Jim Thomlinson

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,



All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com