What version of Excel am I using? Posted on 15 Feb 17. By Henrik Schiffner. Look up the version number of your current Excel version. Where can I check the exact version of Excel? To check the Version from Excel 2016 start Excel an click on File / Account. On the right side you see the office main version. In the scrrenshot it is 2016. Below you find the exact version. In the screenshot it is 1707 (Build 8326.2096).
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. Jun 08, 2020 You should see the 'Version' listing under the 'About Excel' button next to a question mark icon. 4 Click About Excel (if you didn't see the version previously). If you don't see the version number listed next to this icon, you'll find it at the top of the window that pops up.
Dear Friends,
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 🙂
| Version Number | Version Name |
| 8 | Excel 97 |
| 9 | Excel 2000 |
| 10 | Excel 2002 |
| 11 | Excel 2003 |
| 12 | Excel 2007 |
| 14 | Excel 2010 |
| 15 | Excel 2013 |
| 16 | Excel 2016 |
Find Excel Version
Find Excel File Version
How to use this function?
Find Excel Version Number
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.
Latest Version Of Excel
Have a nice weekend !!