Cause
This is caused due to the excel template not being compatible with 2016 version of MS Office when used in 64-bit operating system.
Solution
Use 32-bit operating system to export data to excel template in all versions of MS Office. However, in case of 64-bit operating system the excel template of Karnataka VAT can be used with 2008 version of MS Office.
'New sheet created in Form 100 excel template while exporting data from Tally.ERP 9' has been shared with