I have a problem that one of my excel files have gotten unusually big and because fo thei also very slow.
I have identified the reason and it seems that 6 different sheets suddenly take up much more space than needed maybe because we are converting it from XLS format to XLSM as a part of coding new macros. The sheet is the primary way of managing the economy of our construction process and has been build up over the last 20 years and contains about 3000 lines of macro code and hundreds of named fields etc. So starting over is not really an option in the short run.
But as I said I have identified the offending sheet and I deleted all the other sheets in the workbook. I then deleted all the macros and finally i had a workbook that is about 2.6 mb in size. I then delete all the data in evet possible way i can think of. I simply select the entire sheet and delete all the data. I also tried the option to clear data and selected all. I checked that there is no conditional formatting or links to other files. All looks empty but the file is still 2.6 mb large
The only thing I can see is that if I do a CTRL+END I end up in the last row of the sheet but there is no way i can change this.
I have uploaded the file on my dropbox and you can find it here BigFileNoReason.xlsm
I hope you have any good suggestions.
I have identified the reason and it seems that 6 different sheets suddenly take up much more space than needed maybe because we are converting it from XLS format to XLSM as a part of coding new macros. The sheet is the primary way of managing the economy of our construction process and has been build up over the last 20 years and contains about 3000 lines of macro code and hundreds of named fields etc. So starting over is not really an option in the short run.
But as I said I have identified the offending sheet and I deleted all the other sheets in the workbook. I then deleted all the macros and finally i had a workbook that is about 2.6 mb in size. I then delete all the data in evet possible way i can think of. I simply select the entire sheet and delete all the data. I also tried the option to clear data and selected all. I checked that there is no conditional formatting or links to other files. All looks empty but the file is still 2.6 mb large
The only thing I can see is that if I do a CTRL+END I end up in the last row of the sheet but there is no way i can change this.
I have uploaded the file on my dropbox and you can find it here BigFileNoReason.xlsm
I hope you have any good suggestions.