Page 2 of 2 FirstFirst 12
  1.    21 Feb 2016 #11
    Join Date : Sep 2015
    Posts : 17
    Windows 10
    Thread Starter

    I have uninstalled Clean Mem. When I run a macro (Excel 2013) which opens 10 or more large files and then run a macro within each of these files, I often get "insufficient resources"


    I am not sure what is causing this and how to overcome this
      My ComputerSystem Spec
  2.    21 Feb 2016 #12
    Join Date : Sep 2015
    Posts : 17
    Windows 10
    Thread Starter

    Quote Originally Posted by BunnyJ View Post
    I agree,, with 16GB of RAM you really shouldn't be having any issues. My question is what are the apps/software are you using when you encounter these issues??

    Using a tool like this is just really not a solution, IMO.

    I am using Office 2013 (32 bit) and my operating system is Windows 10 64 bit. Office 32 bit can only use a maximum of 2GB of Ram. I have some large Excel Files than uses a lot of resources when the macros are activated
      My ComputerSystem Spec
  3.    21 Feb 2016 #13
    Join Date : Jan 2014
    Oak Ridge TN, USA
    Posts : 24,523
    Windows 10 Pro x64

    Quote Originally Posted by Howardc View Post
    I am using Office 2013 (32 bit) and my operating system is Windows 10 64 bit. Office 32 bit can only use a maximum of 2GB of Ram. I have some large Excel Files than uses a lot of resources when the macros are activated
    Now that's not nice or fun. Here's what I could find and it's directly from MS so I hope this can help you out.,

    https://support.microsoft.com/en-us/kb/3066990

    Take care and please report back..
    Jeff
      My ComputerSystem Spec
  4.    21 Feb 2016 #14
    Join Date : Sep 2015
    Posts : 17
    Windows 10
    Thread Starter

    Quote Originally Posted by BunnyJ View Post
    Now that's not nice or fun. Here's what I could find and it's directly from MS so I hope this can help you out.,

    https://support.microsoft.com/en-us/kb/3066990

    Take care and please report back..
    Jeff
    Looks like I am going to have to install Office 2013 64 Bit as the 32 Bit can only use a maximum of 2GB's of RAM. My only concern is that I may have to amend mall my declare variables in VBA and I have several hundred workbooks
      My ComputerSystem Spec
  5.    21 Feb 2016 #15
    Join Date : Jan 2014
    Oak Ridge TN, USA
    Posts : 24,523
    Windows 10 Pro x64

    Quote Originally Posted by Howardc View Post
    Looks like I am going to have to install Office 2013 64 Bit as the 32 Bit can only use a maximum of 2GB's of RAM. My only concern is that I may have to amend mall my declare variables in VBA and I have several hundred workbooks
    Oh wow.. that would stink but if you have to get the 64 bit that's something you might have to do.
    Jeff
      My ComputerSystem Spec
  6.    21 Feb 2016 #16
    Join Date : Aug 2014
    Forever West
    Posts : 3,986
    Win10 Home and Pro, Win10 Insider Preview, Win7 Home, Linux Mint

    Quote Originally Posted by BunnyJ View Post
    Now that's not nice or fun. Here's what I could find and it's directly from MS so I hope this can help you out.,

    https://support.microsoft.com/en-us/kb/3066990

    Take care and please report back..
    Jeff
    That's probably why I have no such problem with Office 2010 on Win7 w/8GB or Office 2013 on Win10 w/6GB, both are 64-bit versions of Office. Office 2010 was the first to be available as either 32-bit or 64-bit but I did find the 64-bit install didn't like having any 32-bit applications still installed such as FrontPage 2003.
      My ComputerSystem Spec
  7.    22 Feb 2016 #17
    Join Date : Sep 2015
    Posts : 17
    Windows 10
    Thread Starter

    Hi Guys

    Thanks for your input. I am going to load Office 64 Bit on my Laptop and test, before loading on my work PC
      My ComputerSystem Spec
  8.    24 Feb 2016 #18
    Join Date : Sep 2015
    Posts : 17
    Windows 10
    Thread Starter

    I installed Office 2013 64 Bit version on my Laptop today. So far so good. Have had many files opened and run macro on several of the opened files without any issues whatsoever


    The downside is that some utilities for Office only work with 32 Bit office for eg ASAP utilities
      My ComputerSystem Spec

 
Page 2 of 2 FirstFirst 12


Similar Threads
Thread Forum
FSX out of memory
Since upgrading to win 10 pro 64-bit, I now get OOM from FSX. My worst one is iFly 737. In win 7 I had no problems. I even started at a default airport with my ifly 737 and once in the air, headed out over the ocean. Using VAS monitor, the...
Gaming
High memory usage / Memory leak caused by Intel driver
Hello, I'm running a 64 bit Windows 10 laptop. On idle, the System process is showing a high memory usage of more than 150 MB, usually more than 200 MB. Using poolmon the pooltag SpDN showed up with a memory leak. It leads to the Intel Matrix...
Performance & Maintenance
Solved Memory
I just did my first Hyper-V machine. Fedora 23 Linux. near the end it showed low on resources. The original had memory set at 1024 and so before starting the machine again I changed the memory to 2048. the host which is a HP all in one 23...
Virtualization
Low Memory Warning - Virtual Memory Settings?
As soon as I fired up Sony Vegas 13 and started to record (setting up the microphone was a whole other issue), I was presented with a Low Memory Warning (in Sony Vegas). Personally I think I should have adjusted the Virtual Memory ages ago (Win7),...
Drivers and Hardware
Solved Memory
I don't know if this is the right place for this, but I don't think it should be in the BSOD group. All of my HPs are giving me memory errors when I shut down Build 10130. The error is: 0x00007FF94A95CC60 for this desktop and...
General Support
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 04:17.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App



Windows 10 Forums