I have an Excel file that is encrypted using a password "Master.xlsx" that lives on a shared drive. I create a local workbook and enter a formula (VLOOKUP) referencing "Master.xlsx". If I type an incorrect password, I do get the "incorrect password" error message, but the VLOOKUP still runs and returns correct values from "Master.xlsx". Is this a known issue? Anyone know what's going on?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula bypasses Excel password?
- Thread starter drayl0
- Start date
Similar threads
- Question
- Question
