Cannot set a password
 

I have a couple of spreadsheets that I want to set password.
I did:
Prepare - Encrypt Document - type a password - Confirm a password

When I try to close the file, it says:
"Microsoft Office Excel canno access the file ..... There are several
possible reasons.
*The file name or path does not exist.
*The file is being used by another program.
*The workbook you are trying to save has the same as a currently open
workbook."

Is there a way to fix this?
Thank you in advance.

Cannot set a password
 

Do any of the reasons apply?

Fix it/them first.

But why are you wanting to Encrypt just to add a password to open?


Gord Dibben MS Excel MVP

On Fri, 19 Oct 2007 12:54:01 -0700, HKB wrote:

I have a couple of spreadsheets that I want to set password.
I did:
Prepare - Encrypt Document - type a password - Confirm a password

When I try to close the file, it says:
"Microsoft Office Excel canno access the file ..... There are several
possible reasons.
*The file name or path does not exist.
*The file is being used by another program.
*The workbook you are trying to save has the same as a currently open
workbook."

Is there a way to fix this?
Thank you in advance.

Cannot set a password
 

"Gord Dibben" wrote:

Do any of the reasons apply?

No, none of them apply.

But why are you wanting to Encrypt just to add a password to open?

Because it contains credit card numbers and SSN, etc.

Do you have any ideas how to fix it?

Cannot set a password
 

The word "Prepare" in the statement

"Prepare - Encrypt Document - type a password - Confirm a password"

is not familiar to me using Excel 2003

Is this the 2007 version you are running?


Gord

On Fri, 19 Oct 2007 18:11:00 -0700, HKB wrote:



"Gord Dibben" wrote:

Do any of the reasons apply?

No, none of them apply.

But why are you wanting to Encrypt just to add a password to open?

Because it contains credit card numbers and SSN, etc.

Do you have any ideas how to fix it?