File size grows enormously
I have an Excel sheet with lost of VBA code in. This
includes forms. The file is about 3mb big. Recently, if I only include minimal code and save it, it will be 6mb, next save :12 mb ect. I realised this after my computer kept crashing, that my file is 120mb big!! please help! |
File size grows enormously
Hi Chris,
Three suggestions: 1. See Debra Dalgleish's recommendations: http://www.contextures.com/xlfaqApp.html#Unused 2. Download Rob Bovey's CodeCleaner AddIn: http://www.appspro.com/Downloads/CodeCleaner.exe 3. Use both of the above. --- Regards, Norman "Chris" wrote in message ... I have an Excel sheet with lost of VBA code in. This includes forms. The file is about 3mb big. Recently, if I only include minimal code and save it, it will be 6mb, next save :12 mb ect. I realised this after my computer kept crashing, that my file is 120mb big!! please help! |
File size grows enormously
Thanks Norman.
The code cleaner does not solve my problem. I opened a 9mb file, ran the codecleaner, and after saving it as another filename, it was 16 mb. Which recommendations of Debra do you mean? (Its not that my system crash, the file sizes just keeps growing when I save them) -----Original Message----- Hi Chris, Three suggestions: 1. See Debra Dalgleish's recommendations: http://www.contextures.com/xlfaqApp.html#Unused 2. Download Rob Bovey's CodeCleaner AddIn: http://www.appspro.com/Downloads/CodeCleaner.exe 3. Use both of the above. --- Regards, Norman "Chris" wrote in message ... I have an Excel sheet with lost of VBA code in. This includes forms. The file is about 3mb big. Recently, if I only include minimal code and save it, it will be 6mb, next save :12 mb ect. I realised this after my computer kept crashing, that my file is 120mb big!! please help! . |
File size grows enormously
John Walkenbach refers to this problem on his website.
The best way around it is: 1. Save a copy of the workbook (somewhere safe) 2. Remove all forms and modules (say YES to export them) 3. Save the workbook (not over that saved in 1 above !!) 4. close the workbook 5. Open the workbook in 3 above 6. import the forms and modules 7. Save the workbook. This should result in a considerable decrease in size. By the way - I have used this successfully for years, and it always works Good luck -----Original Message----- Thanks Norman. The code cleaner does not solve my problem. I opened a 9mb file, ran the codecleaner, and after saving it as another filename, it was 16 mb. Which recommendations of Debra do you mean? (Its not that my system crash, the file sizes just keeps growing when I save them) -----Original Message----- Hi Chris, Three suggestions: 1. See Debra Dalgleish's recommendations: http://www.contextures.com/xlfaqApp.html#Unused 2. Download Rob Bovey's CodeCleaner AddIn: http://www.appspro.com/Downloads/CodeCleaner.exe 3. Use both of the above. --- Regards, Norman "Chris" wrote in message ... I have an Excel sheet with lost of VBA code in. This includes forms. The file is about 3mb big. Recently, if I only include minimal code and save it, it will be 6mb, next save :12 mb ect. I realised this after my computer kept crashing, that my file is 120mb big!! please help! . . |
All times are GMT +1. The time now is 12:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com