ChatterBank1 min ago
Passwords on Excel and Word documents
3 Answers
If you have a password on an excel and a word document, why is it that after you have edited the word document, then save it, you need to put the password in again. You do not have to put the password in again on excel.
Answers
Best Answer
No best answer has yet been selected by giggles321. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.I'm guessing here, but with Excel are you perhaps confusing worksheet/workbook "protection" with file security?
If you are using worksheet/workbook 'protection', the password you set only applies to certain elements within said worksheet/workbook. (e.g cell locking, cell formatting, etc); it doesn't set a password for actually opening the spreadsheet. To do this - and thus replicate the behaviour of MS Word - you need to navigate to Tools->Options->Security tab and set a password in the "password to open" box.
(I should point out the above answer is based on Office 2003 products, but I imagine it will be the same sort of thing for other versions.)
If you are using worksheet/workbook 'protection', the password you set only applies to certain elements within said worksheet/workbook. (e.g cell locking, cell formatting, etc); it doesn't set a password for actually opening the spreadsheet. To do this - and thus replicate the behaviour of MS Word - you need to navigate to Tools->Options->Security tab and set a password in the "password to open" box.
(I should point out the above answer is based on Office 2003 products, but I imagine it will be the same sort of thing for other versions.)
-- answer removed --
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.