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