I need to determine which Office to go with 2013 version. 32 or 64.
Currently users are running Office 2010 64-bit. Going to Off365 2013, debating between two (32/64).
Wondering what everyone's experiences with these and opinions. Thanks!
Here are some of the differences/considerations when reviewing 32-bit Office vs. 64-bit Office:
Choose the 32-bit or 64-bit version of Office
There are two versions of Office available to install: 32-bit and 64-bit. Which version is right for you depends on how you plan to use Office.
The 64-bit version of Office has some limitations, but is the right choice when:
• You work with extremely large data sets, like enterprise-scale Excel workbooks with complex calculations, many PivotTables, connections to external databases, PowerPivot, PowerMap, or PowerView. The 64-bit version of Office may perform better for you.
• You work with extremely large pictures, videos, or animations in PowerPoint. The 64-bit version of Office may be better suited to handle these complex slide decks.
• You work with extremely large Word documents. The 64-bit version of Office may be better suited to handle Word documents with large tables, graphics, or other objects.
• You’re working with files over 2GB in Project 2013, especially if the project has many subprojects.
• You want to keep the 64-bit version of Office that you’re already using. The 32-bit and 64-bit versions of Office programs aren’t compatible, so you can’t install both on the same computer.
• You’re developing in-house Office solutions, like add-ins or document-level customizations.
• Your organization requires Hardware Data Execution Prevention (DEP) be enforced for Office applications. DEP is a set of hardware and software technologies that some organizations use to enhance security.
If none of these situations apply to you, the 32-bit version of Office is probably the right choice.
Note The 32-bit version of Office works well with both the 32-bit and the 64-bit versions of Windows. If you are installing the 64-bit version of Office, you need the 64-bit version of Windows. If you’re not installing on Windows, you don’t need to worry about 32-bit or 64-bit options. Which version of Office do I have?
This is important before you install
If you have a version of 32-bit or 64-bit Office in your computer and you want to install Office 2013 or Office 365 or an Office stand-alone application like Visio, you have to install the corresponding 32-bit or 64-bit version of the other program. For example, if your computer has a 32-bit version of Office 2010 and you want to install Office 2013, you have to install the 32-bit version. You can't mix 32-bit and 64-bit versions of Office. For details, see “Office (64-bit) couldn’t be installed” error when you install Office 2013 or Office 365.
Note If you decide to switch from 32-bit Office to 64-bit Office, you need to uninstall the 32-bit version first, and then you can install the 64-bit version.
Limitations of the 64-bit version of Office
The 64-bit version of Office may perform better in some cases, but there are limitations:
• Solutions using ActiveX controls library, ComCtl controls won’t work.
• Third-party ActiveX controls and add-ins won’t work.
• Visual Basic for Applications (VBA) that contain Declare statements won’t work in the 64-bit version of Office without being updated.
• Compiled Access databases, like .MDE and .ACCDE files, won’t work unless they’re specifically written for the 64-bit version of Office.
• In SharePoint, the list view won’t be available.
If you have specific add-ins that you use in the 32-bit version of Office, they may not work in 64-bit Office, and vice versa. If you’re concerned, check your current version of Office before installing the new one. Considering testing the add-in with 64-bit Office, or finding out if a 64-bit version of the add-in is available from the developer.