64-bit VBA provides the LongLong data type which fully supports large numbers.
You’re working with the Large Number data type in Access, and while this data type is supported by 32-bit Access, you may see unexpected results when executing code or expressions that use native 32-bit VBA libraries. In-house Office solution developers should have access to the 64-bit Office 2016 for testing and updating these solutions. Using the 64-bit version of Office lets you deliver a 64-bit version of those solutions as well as a 32-bit version. You’re developing in-house Office solutions like add-ins or document-level customization.
You’re working with files over 2 GB in Project, especially if the project has many sub-projects. The 64-bit version of Office may be better suited to handle these complex slide decks. You’re working with extremely large pictures, videos, or animations in PowerPoint. See Excel specifications and limits, Data Model specification and limits, and Memory usage in the 32-bit edition of Excel. The 64-bit version of Office may perform better in these cases. You’re working with large data sets, like enterprise-scale Excel workbooks with complex calculations, many pivot tables, data connections to external databases, Power Pivot, 3D Map, Power View, or Get & Transform. Therefore, if your scenarios include large files and/or working with large data sets and your computer is running 64-bit version of Windows, 64-bit is the right choice when: Also, 64-bit applications can access more memory than 32-bit applications (up to 18.4 million Petabytes). Reasons to choose the 64-bit versionĬomputers running 64-bit versions of Windows generally have more resources such as processing power and memory, than their 32-bit predecessors. If you're still not sure which version, 32-bit or 64-bit is a better choice for you, see the section below. See “Office (64-bit or 32-bit) couldn’t be installed” error.
The same is true if you installed the 32-bit version, but want to install the 64-bit version. For more details on the differences between the two versions, refer to Microsoft's documentation.Important: If you install the 64-bit version, but want the 32-bit version instead, you must first uninstall the 64-bit version before installing the 32-bit version. If you already have the 32-bit version installed, you'll need to uninstall it before installing the 64-bit version. Remember that you can't have both the 32-bit and 64-bit versions of Office installed at the same time. Step 6: Once you've downloaded the 64-bit installer, run the setup and complete the installation. Step 5: In the version drop-down box, select 64-bit, then click the Install button. Step 4: Click on the "Additional install options" link. Step 3: Click on the "Language and install options" link under the Available Installs section. Step 2: Click on the "My Account" shortcut. Step 1: Go to and log in using your Microsoft account.
Here's how to install the 64-bit version of Office: However, there may be instances when you'd want the 64-bit version, like if you're using a very large database or worksheet.
Microsoft recommends the 32-bit version, even on 64-bit systems, to avoid compatibility issues with third-party add-ons. Office 365 is installed as a 32-bit program on your Windows PC by default. How and where to buy Office 365 and Office 2013.Microsoft Office 2013: Everything you need to know (FAQ).How to use Office on any PC with Office on Demand.