ITR password ?

I downloaded ITR-2 excel utility from incometaxefiling.gov.in website, the 2nd worksheet of the form is password protected. Do you all have the same problem? I don't know the password to unprotect the worksheet so that I can put data in the same. Any help?

Thanks.

Replies (14)
Quick Summary
ITR Excel sheets are not fully password protected; only formula cells are locked. Users need to enable macros in Excel to input data properly. Once enabled, fields auto calculate and allow data entry without needing a password.

No.

Sheet is not password protected only formula cells are password protected...

DEAR MIHIR

Sheet is not password protected only formula CELLS ARE PASSWORD PROTECTED,THEY WILL GET FILLED AUTOMATICALLY AS U FILL UP REST OF THE ITR...

Originally posted by : Mihir

I downloaded ITR-2 excel utility from incometaxefiling.gov.in website, the 2nd worksheet of the form is password protected. Do you all have the same problem? I don't know the password to unprotect the worksheet so that I can put data in the same. Any help?

Thanks.

Dear Mihir

1st you have to reduce security level of excel.

go to excel option(clicking northwest corner icon on the screen) --- trust center--macro setting-enable all macro.

then open the return preparation excel utility.

 

Dear Mihir

1st you have to reduce security level of excel.

go to excel option(clicking northwest corner icon on the screen) --- trust center--macro setting-enable all macro.

then open the return preparation excel utility.


 
 

Dear Amresh,

Did Not Found Such option.........

You need to enable the macro in the excel of your system
Go to Tools > macro > Security > select the medium risk Then reopen the ITR excel file, itwill ask for macro. Just enable it.. Now it will work

Yes, Its done. Thanks a million.

Dear Ayush. if u r using excel 2007.

close all program.

Open excel program> click north west icon ( top left side) > last option i e excel options click > than trust center > macro>enable macro. save changes and close the program.

then open your excel return preparation utility.

DEAR MISHRA,

AS SUGGESTED, I HAVE CHANGED THE OPTION IN TRUST CENTRE.  BUT STILL IN 'SALARY' TOTAL OF THE SALARY IS NOT GENERATED AND ALSO NOT ALLOWED TO INPUT THE FIGURE MANUALLY.  KINDLY GUIDE

 

I have downloaded new ITR form 3 in which cell that a need to enter Adhar is protected . So I unable to enter adhar no which is compulsory. Give solutions please
Latest ITR Form 3 in sheet 1 Adhar card no cell is protected . I unable to enter adhar no. In it . How to unprotected cell or enter adhar no.

Despite of enabling all macros, income details entry is protected. When trying to unprotect, it is asking password. Please help.

Dear sir

 

I am filing revised return ITR 5 the error in CFL Sheet 

 

When I have selected  filing section 139(5)-revised return  then  current year losses automatically calculate in CFL Sheet.  I want to change Current year losses in CFL Sheet due to return was file after due date ( and a notice received from Income tax department    notice attached)

 

When I have selected filing section 139(4) Belated return after the due date then current year losses are manually calculated in CFL Sheet

 

Please change in CFL Sheet for Current year Losses 

 

I want to change Current year losses (AY 2019-20) in  CFL Sheet due to return file after due date and notice u/s 143(1) (a) received from income tax department 


VISHNU KUMAR

 

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 11 September 2026
Audit Executive

RBSM Corporate Advisors Private Limited

Pune

CA

View Details
Company
ARTICLESHIP 01 September 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
04 September 2026
CA inter Or ca finalist

A Jaiswal and company

Lucknow

CA Final

View Details
Company
17 August 2026
Chartered Accountant with US GAAP Experience

Austin Med Solutions Pvt Ltd

Bengaluru

CA

View Details
Company
Featured 19 August 2026
Chartered Accountant

apricus india

Pune

CA

View Details
Company
ARTICLESHIP 24 August 2026
Chartered Accountant Articles

Rohit KC Jain & Co

New Delhi

CA Inter

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
25 August 2026
Senior Accountant

MG Associates

New Delhi

CA Inter

View Details