Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Template becomes Unprotected
I have created an Expense Template for associates to use. All formulas are
protected and some cells are unlocked so they can make entires. Every once in awhile I get an expense template back and a formula has been modified - I know that no one knows the password - how can the formulas be changing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Template becomes Unprotected
#1
Are you sure they are using your template, not a new file they've dummied up to look just like your template? Compare those modified files to your template by checking File-Properties and looking to see if the Author is the same. #2 If they are using your template, be aware that cracking the protection on a worksheet is pretty simle. There are utilities that Google can find for you that will do it. "Erika" wrote: I have created an Expense Template for associates to use. All formulas are protected and some cells are unlocked so they can make entires. Every once in awhile I get an expense template back and a formula has been modified - I know that no one knows the password - how can the formulas be changing? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Template becomes Unprotected
Erika
Are you sure you have enabled Worksheet Protection after protecting cells? Having said that.................Excel security is very poor when it comes to worksheet passwords and protection. Send me your file and I'll crack your password in seconds, change your formulas and send it back to you. Gord Dibben MS Excel MVP On Mon, 6 Mar 2006 09:34:39 -0800, Erika wrote: I have created an Expense Template for associates to use. All formulas are protected and some cells are unlocked so they can make entires. Every once in awhile I get an expense template back and a formula has been modified - I know that no one knows the password - how can the formulas be changing? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Template becomes Unprotected
I know that cracking passwords is very easy to do but when the formulas do
not calculate correctly - the reimbursement they are receiving is not accurate and they are actually losing money so I don't think they are modifying the formulas on purpose. "Gord Dibben" wrote: Erika Are you sure you have enabled Worksheet Protection after protecting cells? Having said that.................Excel security is very poor when it comes to worksheet passwords and protection. Send me your file and I'll crack your password in seconds, change your formulas and send it back to you. Gord Dibben MS Excel MVP On Mon, 6 Mar 2006 09:34:39 -0800, Erika wrote: I have created an Expense Template for associates to use. All formulas are protected and some cells are unlocked so they can make entires. Every once in awhile I get an expense template back and a formula has been modified - I know that no one knows the password - how can the formulas be changing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=IF problem | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Need One Excel Template to copy to TWO Databases | Excel Discussion (Misc queries) | |||
How do you open a template at startup? | Excel Discussion (Misc queries) | |||
How to use a template when inputting csv files? | Excel Discussion (Misc queries) |