Passwords on Excel and Word documents

[giggles321]

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.

[Sputnik]

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.)

[giggles321]

I see what you mean, in word its, tools, security options, where as in excel its tools, general options.