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
- Gst registered proprietorship firm
- TDS Challan - change of FY 2025-26 to TY 2026-27
- Price inclusive or exclusive of GST while made entry in P& L Account
- AUDITOR APPOINTMENT FOR THE YEAR ENDING MARCH 27
- Minimum tax payable to file Updated return
- UDIN ISSUE
- GST ISSUE OF INPUT AND OUTPUT GST
- GST Intimation due to Government took possession of Business Premises under PPE Act
- Salary from Qatar in Dollars in India
- Change Of Karta In Case of Death
- Non filing of I T Returns
- How to Handle Active E-Invoices in GST Portal Deleted from Tally?
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Starting trading business
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
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
