Memory Optimiser

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

BunnyJ said:

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

BunnyJ said:

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

BunnyJ said:

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.

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

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