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


"Ann @ Staples" wrote:

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...