size of workbook

cpc · May 10th, 2002, 01:46 PM

Strange..... I do not understand why my files are so different in size.

I have a workbook with 3 sheets, 5 pages per sheet. (all pages are the same) If I delete the last four pages of all three sheets, the size of page one for all three sheets is 85kb. But if I delete page 1 from all three sheets, the remaining file (the remaining 4 pages on all three sheets) has only been reduced in size by 25kb. Why?

Another look. I have two files. The second being a copy of the first. The second file, with a few minor changes (like =c6 to =$c$6) is almost 35% larger. Why?

Joe Was · May 10th, 2002, 04:10 PM

In Excel and depending on which version you use, things go on in the background which you may be aware of or not and use or not. In any case these "things" are updated.

Like who the author is, if their are links or not, if edits were done, if the clip board was used and what is on it, VBA house-keeping, results of the last calculate and a multitude of object variables just in case you chose to use some funtion, tool, option or property. Depending on what the history of the last open before save was you may or may not trigger a pantheon of behind-the-scenes work all requiring differen amounts of storage, hence the changes in file size. Hope this helps. JSW

[ This Message was edited by: Joe Was on 2002-05-10 15:14 ]

Jack in the UK · May 11th, 2002, 03:26 AM

be awair it can happen windows reports files in different sizes regardless they can be exact copy

one reason it where they are store on the Hard Drive, and the allocation system to space ir if it crosses a sector or cluster or over the 32kb section it will repost bigger... windows ermmm,....

advanced utilitys that tidy hard drives can solve this.... but not worth the agro really, 50 100k files are fine and take little space, amusing i agree..

May 11th, 2002, 03:26 AM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	be awair it can happen windows reports files in different sizes regardless they can be exact copy one reason it where they are store on the Hard Drive, and the allocation system to space ir if it crosses a sector or cluster or over the 32kb section it will repost bigger... windows ermmm,.... advanced utilitys that tidy hard drives can solve this.... but not worth the agro really, 50 100k files are fine and take little space, amusing i agree.. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 01:46 PM	#1
cpc New Member Join Date: Mar 2002 Posts: 38	Strange..... I do not understand why my files are so different in size. I have a workbook with 3 sheets, 5 pages per sheet. (all pages are the same) If I delete the last four pages of all three sheets, the size of page one for all three sheets is 85kb. But if I delete page 1 from all three sheets, the remaining file (the remaining 4 pages on all three sheets) has only been reduced in size by 25kb. Why? Another look. I have two files. The second being a copy of the first. The second file, with a few minor changes (like =c6 to =$c$6) is almost 35% larger. Why?

May 10th, 2002, 04:10 PM	#2
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	In Excel and depending on which version you use, things go on in the background which you may be aware of or not and use or not. In any case these "things" are updated. Like who the author is, if their are links or not, if edits were done, if the clip board was used and what is on it, VBA house-keeping, results of the last calculate and a multitude of object variables just in case you chose to use some funtion, tool, option or property. Depending on what the history of the last open before save was you may or may not trigger a pantheon of behind-the-scenes work all requiring differen amounts of storage, hence the changes in file size. Hope this helps. JSW [ This Message was edited by: Joe Was on 2002-05-10 15:14 ]