prpri How to Enable Macros in Microsoft Excel For Income Tax Return (ITR) How to Enable Macros in Microsoft Excel For Income Tax Return (ITR)

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:

More Under Income Tax

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

Cancel reply

Leave a Comment to AMIT

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

Search Posts by Date

August 2021
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031