Our application has a concept of allowing users to set up Excel template files with formulas that refer to named ranges which will only be created after the fact. While everything works fine with .xls and .xlsx files, we…...total of 4 named ranges to be present in the final output, with names...rangeName and rangeNameC are not present when opening the final result...