Choose between the 32-bit and 64-bit versions of Office

3

This post should help you choose between the 32-bit and 64-bit versions of Office. There are two versions of Office available to install 32-bit and 64-bit. Based on your requirement, you have a option to install 32 bit or 64 bit version of office. When you install Microsoft office on your computer the 32-bit version of Office is installed by default. Even on 64-bit Windows operating systems when you run the office install, 32-bit office is installed. Microsoft recommends 32-bit version of Office for most users, because it’s more compatible with most other applications. In this post we will try to understand the difference between the 32-bit and 64-bit versions of Office. We will also understand when to use 64 bit office and limitations of 64-bit version office.

When to use 64-bit office and Limitations of the 64-bit version of Office

[vc_table vc_table_theme=”classic_blue”][borders_all]When Should you use 64-bit version of office,[borders_all]Limitations of 64-bit version of office|[borders_all]You%20work%20with%20extremely%20large%20data%20sets%2C%20like%20enterprise-scale%20Excel%20workbooks%20with%20complex%20calculations%2C%20many%20PivotTables%2C%20connections%20to%20external%20databases%2C%20PowerPivot%2C%20PowerMap%2C%20or%20PowerView.%20The%2064-bit%20version%20of%20Office%20may%20perform%20better%20for%20you.,[borders_all]Solutions%20using%20ActiveX%20controls%20library%2C%20ComCtl%20controls%20won%E2%80%99t%20work.%20There%20are%20many%20ways%20for%20developers%20to%20work%20around%20this%2C%20and%20provide%20you%20with%20a%2064%20bit%20solution.|[borders_all]You%20work%20with%20extremely%20large%20pictures%2C%20videos%2C%20or%20animations%20in%20PowerPoint.%20The%2064-bit%20version%20of%20Office%20may%20be%20better%20suited%20to%20handle%20these%20complex%20slide%20decks.,[borders_all]32-bit%20third-party%20ActiveX%20controls%20and%20add-ins%20won%E2%80%99t%20work.%20The%20vendor%20would%20need%20to%20create%2064-bit%20versions%20of%20these%20controls.|[borders_all]You%20work%20with%20extremely%20large%20Word%20documents.%20The%2064-bit%20version%20of%20Office%20may%20be%20better%20suited%20to%20handle%20Word%20documents%20with%20large%20tables%2C%20graphics%2C%20or%20other%20objects.,[borders_all]Visual%20Basic%20for%20Applications%20(VBA)%20that%20contain%20Declare%20statements%20won%E2%80%99t%20work%20in%20the%2064-bit%20version%20of%20Office%20without%20being%20updated.|[borders_all]You%E2%80%99re%20working%20with%20files%20over%202GB%20in%20Project%2C%20especially%20if%20the%20project%20has%20many%20subprojects.,[borders_all]Compiled%20Access%20databases%2C%20like%20.MDE%20and%20.ACCDE%20files%2C%20won%E2%80%99t%20work%20unless%20they%E2%80%99re%20specifically%20written%20for%20the%2064-bit%20version%20of%20Office.|[borders_all]You%20want%20to%20keep%20the%2064-bit%20version%20of%20Office%20that%20you%E2%80%99re%20already%20using.%20The%2032-bit%20and%2064-bit%20versions%20of%20Office%20programs%20aren%E2%80%99t%20compatible%2C%20so%20you%20can%E2%80%99t%20install%20both%20on%20the%20same%20computer.,[borders_all]In%20SharePoint%202010%20or%20earlier%2C%20the%20datasheet%20view%20won%E2%80%99t%20be%20available%20because%20this%20view%20uses%20an%20ActiveX%20control.|[borders_all]You%E2%80%99re%20developing%20in-house%20Office%20solutions%2C%20like%20add-ins%20or%20document-level%20customizations.,[borders_all][/vc_table]

Note – When you run an office setup that has both the 32-bit and the 64-bit version on it, you’ll be installing the 32-bit version of Office by default. When you press the Customize button in Setup, you’ll see the Platform tab if your system can support a 64-bit installation of Office.

Choose between the 32-bit and 64-bit versions of Office

As mentioned before, Microsoft recommends the 32-bit version of Office for most users, because it’s more compatible with most other applications, especially third-party add-ins. For an add-in to work with the 64-bit version of Office, it needs to be recompiled by the developer specifically for the 64-bit version of Office. In some cases the developer also needs to make some specific changes for 64-bit support or needs to wait for specific libraries, that the add-in relies on, to be recompiled for 64-bit.

 

Can i run 32-bit and 64-bit versions of Office on the same computer – No this is not possible. Office doesn’t support running side-by-side installations of 64-bit and 32-bit versions of Office. For example, you can’t install Office 2010 32-bit side-by-side with Office 2013 64-bit. This applies to both Windows Installer (MSI) and Click-to-Run installations of Office 2013. If you try to do this, you’ll receive an error message and be prevented from continuing.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. AcceptRead More