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. 32-bit).Īccording to Microsoft documentation, here are the reasons for choosing either 64-bit or 32-bit Office.

64-bit) by mistake, just uninstall that version and then install the correct version (e.g. If you installed the incorrect version (e.g. When it comes to installing Office, make sure you don’t run both 64-bit and 32-bit versions of Office simultaneously on a computer because this can cause serious compatibility issues. There are some situations where you would benefit from 64-bit version of Office, but those cases are rare and mostly apply to developers or individuals who work with unusually large files. As a general rule, most people should always install 32-bit version of Microsoft Office.

Microsoft office windows 7 64 bit