After saving an excel spreadsheet I decided that I needed to add a password
to protect it. I went through 2 different ways of adding one to it and after
the file was saved I went to re-open it and the file crashed once the
password was entered and I lost everything I did. Is there a way to protect
it without crashing ?

I doubt if password protecting an Excel file would cause it to crash.
Chances are it would have crashed anyway.
You provide no real information in your post, so do not expect much help.
For posting tips see ... http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"kmb0702"
wrote in message
After saving an excel spreadsheet I decided that I needed to add a password
to protect it. I went through 2 different ways of adding one to it and after
the file was saved I went to re-open it and the file crashed once the
password was entered and I lost everything I did. Is there a way to protect
it without crashing ?

All I can say that is that spreadsheet worked fine until the password was
added. If I knew more about codes and stuff maybe I could provide them but
all the spreadsheet is doing is keeping track of time and costs. Thanks for
the input.

"Jim Cone" wrote:

I doubt if password protecting an Excel file would cause it to crash.
Chances are it would have crashed anyway.
You provide no real information in your post, so do not expect much help.
For posting tips see ... http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"kmb0702"
wrote in message
After saving an excel spreadsheet I decided that I needed to add a password
to protect it. I went through 2 different ways of adding one to it and after
the file was saved I went to re-open it and the file crashed once the
password was entered and I lost everything I did. Is there a way to protect
it without crashing ?

You say you went through two different ways of adding a password to the file.

Could you please post the two methods you used to set a password to open?

But......I'm with Jim......I don't think adding a password would crash you file.


Gord Dibben MS Excel MVP


On Sat, 30 Dec 2006 08:59:00 -0800, kmb0702
wrote:

All I can say that is that spreadsheet worked fine until the password was
added. If I knew more about codes and stuff maybe I could provide them but
all the spreadsheet is doing is keeping track of time and costs. Thanks for
the input.

"Jim Cone" wrote:

I doubt if password protecting an Excel file would cause it to crash.
Chances are it would have crashed anyway.
You provide no real information in your post, so do not expect much help.
For posting tips see ... http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"kmb0702"
wrote in message
After saving an excel spreadsheet I decided that I needed to add a password
to protect it. I went through 2 different ways of adding one to it and after
the file was saved I went to re-open it and the file crashed once the
password was entered and I lost everything I did. Is there a way to protect
it without crashing ?

First I went through toolsoptionssecuritypassword to opem:

Second was FileSave AsToolsGeneral OptionsPassword to open:



"Gord Dibben" wrote:

You say you went through two different ways of adding a password to the file.

Could you please post the two methods you used to set a password to open?

But......I'm with Jim......I don't think adding a password would crash you file.


Gord Dibben MS Excel MVP


On Sat, 30 Dec 2006 08:59:00 -0800, kmb0702
wrote:

All I can say that is that spreadsheet worked fine until the password was
added. If I knew more about codes and stuff maybe I could provide them but
all the spreadsheet is doing is keeping track of time and costs. Thanks for
the input.

"Jim Cone" wrote:

I doubt if password protecting an Excel file would cause it to crash.
Chances are it would have crashed anyway.
You provide no real information in your post, so do not expect much help.
For posting tips see ... http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"kmb0702"
wrote in message
After saving an excel spreadsheet I decided that I needed to add a password
to protect it. I went through 2 different ways of adding one to it and after
the file was saved I went to re-open it and the file crashed once the
password was entered and I lost everything I did. Is there a way to protect
it without crashing ?

Only one of those would be necessary, but there should be no conflict by setting
at both spots.

Unless you actually chose some sort of Encryption mode from
ToolsOptionsSecurity but I don't know what type of problem that could cause.

Sorry I can offer no assistance further than guessing as I have done to now.


Gord


On Sat, 30 Dec 2006 15:28:00 -0800, kmb0702
wrote:

First I went through toolsoptionssecuritypassword to opem:

Second was FileSave AsToolsGeneral OptionsPassword to open:



"Gord Dibben" wrote:

You say you went through two different ways of adding a password to the file.

Could you please post the two methods you used to set a password to open?

But......I'm with Jim......I don't think adding a password would crash you file.


Gord Dibben MS Excel MVP


On Sat, 30 Dec 2006 08:59:00 -0800, kmb0702
wrote:

All I can say that is that spreadsheet worked fine until the password was
added. If I knew more about codes and stuff maybe I could provide them but
all the spreadsheet is doing is keeping track of time and costs. Thanks for
the input.

"Jim Cone" wrote:

I doubt if password protecting an Excel file would cause it to crash.
Chances are it would have crashed anyway.
You provide no real information in your post, so do not expect much help.
For posting tips see ... http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"kmb0702"
wrote in message
After saving an excel spreadsheet I decided that I needed to add a password
to protect it. I went through 2 different ways of adding one to it and after
the file was saved I went to re-open it and the file crashed once the
password was entered and I lost everything I did. Is there a way to protect
it without crashing ?




Gord Dibben MS Excel MVP