1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

System becomes slow

Discussion in 'VBA Macros' started by Monty, Aug 12, 2017.

  1. Monty

    Monty Well-Known Member

    Messages:
    836
    Hello Everyone!

    I have recently experienced while working on Excel macro with 10 sheets which will moved to new workbook and save as different site and create 54 template.

    So while running though it take's some time to complete the job...but system become dead slow...i think because of system memory uses very much while macro trying to generate temples..

    Question is how to clear the memory and avoid getting an error like no enough space.

    Please suggest.
  2. Deepak

    Deepak Excel Ninja

    Messages:
    2,761
    When extensive task to do then more resources are required! To come out the issue pls ensure that
    You have cleared all unnecessary cells, formats like stuffs from the workbook.
    You have closed the other stuff to free more ram.
    Tasks run one by one on order with a sleep of time & before running the next routine, memory has been cleared from old.

    Few points like as turn off screen updating, display, calculation mode may also play role.

    Install ram as much as you can. More ram less pain.
    Monty likes this.
  3. Monty

    Monty Well-Known Member

    Messages:
    836
    Hello Deepak.

    Hope you are doing good...Thanks for the suggests...
    i have already using turn off screen updating, display calculation mode but still system get struck need to restart the system...As suggested yes Ram play important role as at work we are using 4GB..which is not so easy for company to change...So trying to figure out...how to clear the memory while running the macro.
  4. Deepak

    Deepak Excel Ninja

    Messages:
    2,761
  5. Monty

    Monty Well-Known Member

    Messages:
    836
    Thanks will go through!

Share This Page