Compatibility of calculations with various versions of Excel.

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.

Caution: The combination of Excel 2010 and the *.xls format is worth mentioning. This combination results in irreparable damage to the control elements. For Excel 2010, we therefore strongly recommend use of an installation that includes *.xlsb format calculations.
Useful hint: If you transfer calculations between various Excel versions (e.g. submission to a colleague), we recommend using the function 'Save a copy for a different version of Office', which you can find in the Settings list.

The table of file extensions used in the calculations is located below.

 File  extension  Description
 *.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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

^