Insufficient Resources

Discussion in 'Windows 7 Help and Support' started by Flupsie, Sep 7, 2011.

  1. Flupsie

    Flupsie Well-Known Member

    Joined:
    Jun 9, 2011
    Messages:
    109
    Likes Received:
    0
    Usually after I have run a macro on Excel and truy to open up another workbook , I get a message "Insufficient resources" I use Windows 7 and Office 2010 and have 4GB of RAM.

    It would be appreciated if someone could help me resolve this issue
     
  2. patcooke

    patcooke Microsoft MVP
    Staff Member Premium Supporter Microsoft MVP

    Joined:
    May 16, 2010
    Messages:
    5,456
    Likes Received:
    268
  3. Saltgrass

    Saltgrass Excellent Member
    Microsoft Community Contributor

    Joined:
    Oct 16, 2009
    Messages:
    15,157
    Likes Received:
    393
    You don't have problems opening workbooks if you do not run the Macro? What type of Macro is it and where did it come from?
     
  4. Flupsie

    Flupsie Well-Known Member

    Joined:
    Jun 9, 2011
    Messages:
    109
    Likes Received:
    0
    I think that i may have resolved the problem. Within my macro I usually have application.screenupdating = false which uses a lot of resources

    I have taken out this line of code on some of my workbooks and so far it seems to mnot be causing the problem with 'insufficient resources
     
  5. Flupsie

    Flupsie Well-Known Member

    Joined:
    Jun 9, 2011
    Messages:
    109
    Likes Received:
    0
    Hi Pat

    I eventually resolved the problem a week ago. I engaged the services of an IT professional. At the start button he ran msconfig and disabled non-essential programs at start up, such as Skype, Nero etc that use a lot of resources. He also loaded a memory optimiser. I can now run macro and open several workbooks without encountering any problems. I have tested this for a week now
     
  6. patcooke

    patcooke Microsoft MVP
    Staff Member Premium Supporter Microsoft MVP

    Joined:
    May 16, 2010
    Messages:
    5,456
    Likes Received:
    268
    Well done - freeing up all the resources you have will make much more available and reduce the likelihood that you will hit the limit again. Msconfig is the standard method for managing startup apps but another MS product, autoruns, free from the link below is a much more powerful and comprehensive manager which you might find useful for monitoring startups:

    Autoruns for Windows
     
  7. Flupsie

    Flupsie Well-Known Member

    Joined:
    Jun 9, 2011
    Messages:
    109
    Likes Received:
    0
    Thanks for the reply and the link for autoruns. I will definately make use of this
     
  8. Drew

    Drew Banned

    Joined:
    Mar 25, 2006
    Messages:
    3,575
    Likes Received:
    146
    You mentioned Nero. If, you are running Windows 7, there is no need for Nero or any burning software since 7 does everything natively & there is no longer need for adding burning software. 7 will, even burn ISOs by itself & direct burn to both CDs & DVDs.

    Just saying...

    Drew
     
  9. Flupsie

    Flupsie Well-Known Member

    Joined:
    Jun 9, 2011
    Messages:
    109
    Likes Received:
    0
    Hi Drew

    Thanks for the reply. I have uninstalled Nero as it is no longer required
     
  10. Drew

    Drew Banned

    Joined:
    Mar 25, 2006
    Messages:
    3,575
    Likes Received:
    146
    You're welcome & very cool :thumbs_up::thumbs_up:

    Drew
     

Share This Page

Loading...