Income Tax Department has started to release Excel Based ITR forms for submission of online Income Tax Returns for the Financial Year 2011-12 or Assessment Year 2012-13.
In the First instance Excel Based ITR-1 (Sahaj) form is ready to upload income tax return for the assessment year 2012-13.
To work in excel based utility ITR-1 (SAHAJ), it is mandatory to enable macros. Help.txt file is also available in downloaded zip file which shows that how can an user enable macros in return preparation utility. The same is also explained below for Microsoft Office 2003 , 2007 and 2010.
HOW TO ENABLE MACROS IN MICROSOFT EXCEL FOR RETURN PREPARATION UTILITY
It is necessary to ENABLE the execution of macros in Return-Preparation-Utility in order to enter, validate and generate an .XML file for upload. Follow these steps to ENABLE execution of macros depending on the version of [Microsoft Office Excel] being used to open the Return-Preparation-Utility :[Microsoft Office Excel 2003]
Navigate through the following excel menu option to reduce the level of security in executing macros :
Tools --> Macros --> Security --> Low
OR
Tools --> Macros --> Security --> Medium
Save the excel-utility and re-open it.
[Microsoft Office Excel 2007]
Navigate through the following excel menu options to reduce the level of security in executing macros :
Excel Options --> Trust Centre --> Trust Centre Settings --> Macro Settings --> Enable all macros
AND
Excel Options --> Trust Centre --> Trust Centre Settings --> ActiveX Settings --> Enable all controls without restriction and without prompting
Save the excel-utility and re-open it.
[Microsoft Office Excel 2010]
When you open the EXCEL-UTILITY, the yellow Message Bar appears with a shield icon and the Enable Content button.
Click on the Enable Content to enable the macros.
***