How to Find the Version of Excel with VBA Code
Press Alt + F11 to open the Microsoft Basic for Applications window. Copy and paste the below VBA code into the Module window, and then press the F5 key to run the code. Then a Microsoft Excel dialog box pops up with the version number displaying.
You can easily check Excel version you are using by looking at the menu or the top ribbon. Open any Microsoft Excel file and look at the top left corner of the file. Depending on how the File button looks, you can easily identify the version of Excel.
Another common inquiry is “How do I know what version of Excel I am running?”.
For more information, click on About Excel. A dialog box opens, showing the full version number and bit version ( 32-bit or 64-bit ). Click on the Excel tab from the menu on top of your screen.
When I was reading we ran into the question “How to find the version of Excel 2007?”.
Find the version of Excel 2007. In the Excel Options dialog box, click Resources in left pane, then you can see the Excel version in the about Microsoft Office Excel 2007 section.
A frequent query we ran across in our research was “How to check Microsoft Excel version and build number on Mac?”.
Click on Excel on the Mac Menu Bar and then select About Microsoft Excel. In the About Excel dialog box, all details will be displayed! So, you can either look at the starting screen of the application, the menu ribbon, or the help/about option in Excel to get information like product version, build number, etc.
How do I find the bit version of an Excel file?
For more information, such as the bit-version, choose About Excel. A dialog box opens, showing the full version number and bit version (32-bit or 64-bit). Open any Office application, such as Word and create a new document.