none
File size increases. RRS feed

  • Question

  • Hi all, I have a macro in excel, at first my macro weighed 15 MB, I add 2 sheets and now weighs 138 MB, I realized that in all the leaves had information and format I not had included, I deleted the information and format and now my file weighs 165 mb,I researched and realized several things to reduce the size but nothing works, only increases more, I hope you can help me solve my problem, greetings and thanks.
    Thursday, January 22, 2015 4:50 PM

Answers

  • Some guesses:

    -Check the property Worksheet.ChartObjects.Count of each Worksheet. If it is greater thant the number of Charts in each Worksheet, there are some corrupted data on them.

    -Do the same for the Worksheet.Shapes.Count.

    -Press Ctrl+End to check if that last cell of the Worksheet coincides with the last populated cell. If is not, delete all the extra blank rows and columns.


    Felipe Costa Gualberto - http://www.ambienteoffice.com.br

    • Marked as answer by aslf010990 Friday, January 23, 2015 6:06 PM
    Friday, January 23, 2015 3:57 PM

All replies

  • Can you post the macro code here?

    Felipe Costa Gualberto - http://www.ambienteoffice.com.br

    Thursday, January 22, 2015 10:24 PM
  • It is a bit tricky as there are 11 modules and 4 forms , I really think it's not the problem of code , I think the problem it's in the format of the leaves , but thanks for answering , Greetings
    Friday, January 23, 2015 3:17 PM
  • Some guesses:

    -Check the property Worksheet.ChartObjects.Count of each Worksheet. If it is greater thant the number of Charts in each Worksheet, there are some corrupted data on them.

    -Do the same for the Worksheet.Shapes.Count.

    -Press Ctrl+End to check if that last cell of the Worksheet coincides with the last populated cell. If is not, delete all the extra blank rows and columns.


    Felipe Costa Gualberto - http://www.ambienteoffice.com.br

    • Marked as answer by aslf010990 Friday, January 23, 2015 6:06 PM
    Friday, January 23, 2015 3:57 PM