Menu
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. 1 - Product name, such as Office 365 ProPlus or Office Home and Student. 2 - Version number, which includes version, build number, and the type of installation such as Click-to-run or Windows Store. For more information, such as the bit-version, choose About Excel.
![Excel Excel](/uploads/1/2/5/4/125484936/943611697.png)
A dialog box opens, showing the full version number and bit version (32-bit or 64-bit). See Also.
Mac Excel version and Mac Office language settings Introduction It can be useful to know what the Excel version and the Excel language is of the Excel application that opens your workbook so your code can do different things depending of the version/language. Note: Read also this page Excel Version Number You can use Application.Version to get the version number of Excel as a string. We can use the Val function in Excel to make it numeric so we can test the number. The macro below will display a msgbox with the Excel version, working in Excel for Windows also, you can replace the msgbox line with your code or a Macro call.
Excel: Windows vs. Carlton Collins, CPA. Generally speaking, Excel versions for Mac and Windows are reasonably compatible. The table below summarizes the primary functional differences between the Mac and Windows editions of Excel. If for some reason you cannot use Excel for Mac, then you will need to install Windows on the Mac either through Bootcamp or a Virtualization.
Sub TestMacOrWindowsOfficeVersion 'Test the conditional compiler constants #If MACOFFICEVERSION = 15 Then MsgBox 'Excel 2016 for the Mac, version: ' & Val(Application.Version) Exit Sub #End If #If Mac Then If Val(Application.Version) =15) to know if your code is runing in Excel 2016. But if you want to avoid compile errors with for example ribbon macro callbacks in Excel 2011(this not compile for example in 2011: control As IRibbonControl) or use VBA functions that are new in 2016 like AppleScriptTask and GrantAccessToMultipleFiles, you can add the ribbon macro callbacks or the new VBA functions in between the two code lines below in your code module.
#If MACOFFICEVERSION = 15 Then Put your macro callbacks or code here #End If Excel for Windows always give you a string with the whole number, this are the Windows Excel versions: Excel 97 = 8 Excel 2000 = 9 Excel 2002 = 10 Excel 2003 = 11 Excel 2007 = 12 Excel 2010 = 14 Excel 2013 = 15 Excel 2016 = 16 Note: Mac Excel will not give you a whole number: Mac Excel 2011 = 14.? Mac Excel 2016 = 15.? (when I was released but now it is version 16 if you are up to date, see below) Mac Excel 2016 = 16.11.1 (24-March-2018) Note: You see that Excel 2016 can be version number 15.?
Or 16.?, but if you update Excel you always have version 16.