File size increasing w/o cause Excell '07

[rnhutsko]

Hello all,

I have a file that is a log of sales. This workbook has several sheets and one of them is over 900 rows long. It was originally created in Excel '03 and was migrated to '07 .xlsm format. The file seems to be growing in size. I have copied individually each of the sheets to a new work book and the resulting file is on 936kb in size. The original is 16.4MB+ in size and grows every time you save it. The growth in size does not seem to be in proportion to the type/ssize of data inputed.

Multiple users use this file so it is a shared file on a network server. I do not know where to begin looking for the source nor solution to this problem. The issue is that the file is so large that it locks up or will not open or is VERY slow to load.

Any and all help is appreciated

 

[MarianoMcCoy]

Hi. Maybe that somebody is copying some kind of dificult to see objects to the sheets. Try the following: select all the objects into each sheet, with Edition/Go To/Special/objects. Once selected, delete it all not needed with Del. This occured to me time ago. I've a spanish version of Excel 2000, so may be the path is not the same. OK I hope to be useful. Best regards, Mariano Deheza