Dear Friends,

1. How To Find Excel Version 2010
2. How To Find Excel Version Info
3. How To Find Excel Version Of File
4. How To Find Excel Version In Office 365

Most Excel workbooks contain errors which in some cases lead to unpleasant “surprises”. Spreadsheet errors come in many different flavors: Some of them are easy to spot but others are much more subtle: When you forget to update an external data source for example or when you copy a formula from the cell above instead of from the cell to the left. Or you end up counting some cells twice etc. Open any Office application, such as Word or Excel, and select Account. Note: If you don't see Account or you already have a file or document open, choose File from the menu, and then select either Account or Help from the list on the left. Under Product Information, you'll find your Office product name and, in some cases, the full version number. If you want to save the workbook in the older format, you need to use only colors that are defined in the older versions of Excel. To see these, click on the Office button, pick Excel Options from the bottom of the frame, and go to the Save tab. Click on the Colors. Button, and you'll see the palate available for the older versions. If you’re using Office for Mac, open one of the Office programs, such as Word, and click on the Word (or Excel, PowerPoint, etc.) menu. Select “About Word”. The About Word (or Excel, PowerPoint, etc.) dialog box displays, listing the current version number and the build number. If you see Version 15.x, you’re using Office for Mac 2016. This can be found easily, although the process to find this information is different on each Excel version. Here is a quick guide. This section is intended to Windows users. If you are using a Mac, jump to the second part of this document. Excel 2013, 2016, 2019 (Office 365) Start by clicking on the File button, on the top left.

Usually while working on any of the VBA projects, it becomes important for me to first check the version of excel which user is using and based on that certain functionality of my tool may or may not work. For Example: If you have some sales data using more than 256 columns then if user is using Excel 2003, then it would not be possible as Excel 2003 has got only 256 columns. But if user is using any higher version like Excel 2007 etc. then it is possible to do so without any error as they have got 16000+ columns in it. This way before processing the data if you can identify the version of the excel user is using then you will be able to handle the error without crashing the excel.

As user I would always prefer a clear message stating that “this functionality is not available in so and so Excel version” rather than getting some weird Microsoft error message and messing up other functionalities as well.

It is a very simple piece of code which will determine which version of excel user is using. Whenever you call the bellow function at any moment of time when it is necessary to check the version of the excel.

Important Note:

VBA.Val(Application.Version) returns a number. Each version of the excel can be determined by the following mapping of Version Number and name. Same mapping I have put in the above code:
Do not ask me why version number 13 is missing from the sequence 🙂

How to use this function?

Step 1. Copy the above code
Step 2. Create a publich module in your VBA project
Step 3. Paste this code there
Step 4. Now you are ready to call this function anywhere in your workbook
you can also call this function from you excel cell as a formula and it will return the version of the excel you are using currently.
Enjoy writing full proof VBA code without any unknown error related to excel version. Keep looking in this space for many more such small tips and tricks in VBA.

Have a nice weekend !!

Quantum XL is fully compatible with Windows 32bit and 64bit. However, at the time of writing Quantum XL must be running on 32bit Office/Excel. By default, the Office installer will install the 32bit version. However, if you would like to double check, then follow these steps.

Note: Excel 2007 and earlier are all 32-bit.

Instructions for Excel 2016/2019/Office 465

Instructions for Excel 2013

Instructions for Excel 2010

How to tell if Excel 2016/2019/Office 365 is 32-bit or 64-bit

First, select “File” from the main menu.

How To Find Excel Version 2010

The select “Account” from the left menu.

Then select “About Excel” from the box on the right.

The text at the top of the dialog will show if Excel is 32 or 64 bit.

How To Find Excel Version Info

How to tell if Excel 2013 is 32-bit or 64-bit

First, select “File” from the main menu.

Then select “Account” from the menu on the left. On the right side of the screen is a small box with the words “About”. Despite lacking any visual indication that this is a button, it actually is one. Click on this button.

How To Find Excel Version Of File

At the top of this window after a long sequence of numbers and letters are the words “32-bit” or “64-bit”.

How to tell if Excel 2010 is 32-bit or 64-bit

How To Find Excel Version In Office 365

Select “File” then “Help”. On the right side look for the words “About Microsoft Excel”. Just below you will see the version and either (32-bit) or (64-bit).