Blog on Microsoft and Other Technologies.

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

3 1,022

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.