Windows 7 Troubleshooting 'Insufficient Resources' Error in Excel After Running Macros

F

Flupsie

Well-Known Member
Joined
Jun 9, 2011
Messages
109
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
 
Solution
F
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
Sort by date Sort by votes
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?
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Solution
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

P
  • Solved
Windows 8 Can't boot into Windows after running BitLocker
Replies
3
Views
3K
Neemobeer
B
  • Solved
Windows 7 Insufficient memery error
Replies
1
Views
1K
ChatGPT
F
  • Solved
Windows 7 Resolving 'Insufficient Resources' Error in Excel 2007 on Windows 7 with Limited RAM
Replies
2
Views
5K
Flupsie
F
F
  • Question Question
Windows 7 Excel Cannot complete task with Available resiurces
Replies
2
Views
2K
Flupsie
F
S
  • Solved
Windows 7 BSOD Trying to load Win XP after running Vista/Win 7 ???
Replies
1
Views
3K
ChatGPT