Excel problem
This query is : Resolved
Guest
Guest
(Querist)
11 May 2014
I have given data validation formula in Excel 97-2003 but when I reopen the same file the data validation (list) formula disappears?
Please help
Please help
12 May 2014
Dear Prajakta,
Step:1
Select the Entire worksheet ( CTRL+A). Then CTRL+1--- Format Cells---->Protection Tab---> Remove (Tick Mark) from Locked Option-->Ok.
Step:2
Keeping the Cursor on the cell contains data validation,Ctrl+1----> Format Cell---->Protection Tab---> Select Locked option---> Ok.
Step 3:
Go to Review Tab-----> Protect Sheet with some password.
If the Problem persists, Pls share the file
to "Excelrocker@ymail.com"
Step:1
Select the Entire worksheet ( CTRL+A). Then CTRL+1--- Format Cells---->Protection Tab---> Remove (Tick Mark) from Locked Option-->Ok.
Step:2
Keeping the Cursor on the cell contains data validation,Ctrl+1----> Format Cell---->Protection Tab---> Select Locked option---> Ok.
Step 3:
Go to Review Tab-----> Protect Sheet with some password.
If the Problem persists, Pls share the file
to "Excelrocker@ymail.com"
Guest
Guest
(Querist)
12 May 2014
Thanks for replying But problem not solved
12 May 2014
can u share the file
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- ITR 2 Short Term gain & Long term gain
- Reporting Income under Section 44ADA
- Itr 1 processing
- Off Market debit and credit transaction
- ITR returnFY25-26
- Share accounting-->fifo - capital gain - period as per fifo?
- ITR 1: Details for showing Exempt Income
- ITR validation error - Balance sheet is not filled
- Short Term Capital gain on shares bought and sold after 2018 onwards
- INCOME TAX ON REDEVELOPEMENT OF FLAT
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
