Follow Us :

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.

Some Suggested Posts related to above  

S. No. Link
1 How to use / Enable E-filing Vault on Income Tax
2 Understanding Compliance Query of Income Tax Department
3 Income Tax e-Filing DSC management utility
4 How to File Income Tax Return of a Deceased Assessee?
5 FAQs on filing the return of income
6 For whom e-filing of Income Tax Return (ITR) is Mandatory
7 Guide to know ITR applicable: Which ITR Applicable to whom?
8 How to reset password when activation link not confirmed while registering PAN in Income Tax Department

Republished with Amendments

Tags:

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

7 Comments

  1. K,chandrsekaran says:

    I created the xml file and saved the ITR3 but when i want to make some corrections further in the ITR3 the macro does not run even after doing the enablings in excel options pl

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Post by Date
March 2024
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031