Home |
Search |
Today's Posts |
#1
|
|||
|
|||
locking formula for shared excel spreadsheets
I have a shared excel spreadsheet with filter and formulas, I need to lock or
protect the formula, but when I set protection on the filter column will not work eventhough I have enable the column to be filtered. Please help. |
#2
|
|||
|
|||
This may not help, but its worth trying:
1. Unprotect the worksheet 2. Unlock all cells in the worksheet 3. Lock only the specific cells containing formulae 4. Protect the worksheet -- Gary's Student "MFY" wrote: I have a shared excel spreadsheet with filter and formulas, I need to lock or protect the formula, but when I set protection on the filter column will not work eventhough I have enable the column to be filtered. Please help. |
#3
|
|||
|
|||
What version of excel are you using?
If you're using xl2002+, you can protect the worksheet and allow autofilter on the protection dialog. (It worked ok for me). But in earlier versions (xl2k and before), you have to make a choice: 1. shared, unprotected and allow filter 2. not shared, protected and allow filter If you choose #2, you'll need code to allow the filtering. MFY wrote: I have a shared excel spreadsheet with filter and formulas, I need to lock or protect the formula, but when I set protection on the filter column will not work eventhough I have enable the column to be filtered. Please help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |