ITR password ?

86091 views 14 replies

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

 

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 20 June 2026
Articleship

RB KESHRI & CO

Mumbai

B.Com

View Details
Company
20 June 2026
Chartered Accountant

ANV & Company

New Delhi

CA

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
24 May 2026
Accounts & Tax Executive

PARAS KHURANA AND CO

New Delhi

B.Com

View Details
Company
26 May 2026
Audit executive

vdsr & co LLP

Chennai

CA Inter

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details
Company
27 May 2026
Audit Assitant

Virender K Gupta and Co

New Delhi

B.Com

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details