MITCalc supports a range of versions of Microsoft Excel. Although Microsoft claims that documents saved in various versions of Excel are mutually compatible, this is not entirely true. In the cases of some Excel versions (mainly Excel 2010), damage may occur to the control elements located in hidden areas (buttons, lists, drop-down lists, graphs, etc.) when saving the calculation. Moreover, everything is dependant upon the version of the operating system, the Excel version, the presence of multiple Office versions or Office upgrades, and whether you are opening a calculation saved in a different Excel version (e.g. submission of the calculation to a colleague, transfer of one calculation between different computers, etc.).
Luckily, this damage does not affect formulas and calculated values (the results of calculations are still correct !!!). However, inserted control elements in hidden areas (buttons, lists, select lists, graphs etc.) They may be slightly shifted and dimensionally modified during saving.
This is why we have prepared two installations. The first contains calculations in the *.xls format and is intended for Excel 2000/XP/2003 and 2007 (can also be used in Excel 2013, 2016, 2019). The second installation contains calculations in the *.xlsb format and is intended for Excel 2010,2013,2016,2019. You should use the installation package which works for your version of Excel.
The table of file extensions used in the calculations is located below.
|*.xla||Excel add in (ver. 97, 2000, XP, 2003) contains macros in VBA|
|*.xlam||Excel add in (ver. 2007,2010,2013,2016,2019) contains macros in VBA|
|*.xls||Standard Excel document (ver. 97, 2000, XP, 2003), may contain macros in VBA|
|*.xlsx||Standard Excel document (ver. 2007,2010,2013,2016,2019) does not contain macros in VBA|
|*.xlsm||Standard Excel document (ver. 2007,2010,2013,2016,2019) with support for VBA macros|
|*.xlsb||Excel document (ver. 2007,2010,2013,2016,2019) in binary form with support for VBA macros|