Current Position:Home > Will 64-bit office fix out of memory error?

Will 64-bit office fix out of memory error?

Update:11-30Source: network consolidation
Advertisement
I've been troubleshooting an out of memory error in Excel 2010 for some time. I've read quite a few articles on forums and on MS sites (including here.) I find many hits but none seems to offer a solution that works. One idea that seems to show
up often is that 64-bit Office versions will have a LOT MORE memory to work with than 32-bit versions. I'm running a 64-bit version of Windows 7, so I'm considering giving Office 2010 64-bit a try. However, I also find a lot of caveats in those articles that
concern me. On the other hand most of those articles are 2 to 3 years old, so I'm wondering if most of those issues have been dealt with. For example, VBA issues; third-party add-ins that do not (did not) support 64-bit; ActiveX and COM issues.
Sorry to be overly verbose. My questions pretty much come down to this:
1. Is 64-bit likely to solve my out of memory problem?
2. What issues are still unresolved in 64-bit Excel with Windows 7?
TIA,
Phil

The Best Answer

Advertisement
If you are an Excel power user working with huge amounts of data, then you would benefit from 64-bit Office being able to utilize more memory.
MS is recommending 32-bit Office as the default installation on both 32-bit and 64-bit Windows mainly due to compatibility with existing 32-bit controls, add-ins, and VBA.
This is really not an issue that can be resolved on Office side, it depends on whether you are using any 32-bits controls, add-ins and VBA. The question is those existing 32-bit controls, add-ins and vba need an update to adapter to the 64bit of Office.
If all your controls, add-ins and VBA is 64 bits, or designed to work with 64 bits of Office, then you are good.
Bhasker Timilsina (ManTechs Inc)