Excel: Know if You Have 32-Bit or 64-Bit Excel

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Microsoft has done their best to make sure you ended up with 32-bit Office. If you plan on loading 10 million rows into Power Pivot, you really need 64-bit Office. When you install Office there is a huge button for "œInstall What We Think You Should Have" and a tiny link for "œAdvanced Options" where you can choose 64-bit.

If you plan on downloading any of the free downloads, you will have to know if you have 32-bit or 64-bit Excel installed. You have to download the correct version of the add-in or it will not work.

In Excel 2013, go to File, Account. Click the About Microsoft Excel in the right side of the backstage view. Look just below the title bar of the dialog box, at the end of the version number to see if you have 32-bit or 64-bit. In Excel 2010, go to File, Help. The version number is shown on the right side of the screen.

t

  1. This Excel 2013 is 64-bit.

    As you get to the download sites from Microsoft, they will clearly label the 64-bit with 64 in the file name. The 32-bit will either have "œ32" or "œx86".

  2. Download the correct version to match your Excel 2010.

For more resources for Microsoft Excel