Excel Workbook file increaseing in size

[Ann @ Staples]

The file was created in XL 97 (I think) and is being opened in XL 2002. It
has one sheet. Data in rows 1 - 24 & Columns A - AE. There are cell borders
around these cells and some have shading. During the month (it's a roster)
the file is updated with an 'X' in the cell which corresponds with the day
the employee worked and then saved. The file at present is 5.4MB, in July
it was 3.6MB. The amount/number of data has not changed - just the 'X's'
have been placed into different cells.

Why is it increasing in size this dramatically and why is it this size
anyway?. There are no logos, no back ups, no versions...

 

[Frank Kabel]

Hi
see your other post

 

[Woody]

The problem below is something that I've just found out about and would like
to know why it's happening.
I had a tidy workbook with the MATCH option in place and this worked
efficiently to produce a schedlue (Yep Thanks Bob Umlas it's your basic
design from 2001).

I have a worksheet with approx 3,000 job codes and each has about 30
associated fields i.e. price, time, purchased, acount code which in the main
are between 1 and 35 chars. I was recently upgraded to Office 2003 in mid
February, and this file has grown from 3mb to over 6mb with no increase in
data content.

I have copied the file and applied to my home system with resuolts even
after stripping out 98% of the data tha used for the MATCH process.

This is most concerning as it is taking >2hrs to download via the company'e
netwrk so not very productive at all.

Please would someone suggest what couold be done to overcome this ?

TIA

 

[Woody]

Hi Ann@staples,
I picked up your comment and posted the same question as I could not get to
Frank Kabel reply of "Hi see your other post."
Please can I ask how you got around this problem ?

 

[JohnC]

Woody,

I'm having the same problem (see Excel File Shrink post today). My program
grew from 3 MB to 50 MB+....with no substantial increase in data. It has
something to do with Excel saving equations and data each time you do a save.

If you any help on this, please let me know.

Thanks,
John

 

[Charles Williams]

Make sure the workbook does NOT have Track Changes while Editing switched
on.
If its on Excel will indeed saving changed formulae and data each time you
save.

regards
Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com