Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

Saving with password problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Vanini - 13 Oct 2007 08:39 GMT
I have tried saving an xls sheet under a different name using a password to
stop others from changing the contents but I can't seem to get it to work.

I go to "File", "Save as", and then click on "Tools" on the "Save As"
dialogue box that comes up.

I choose "General Options" and enter a new password in "Password to Modify"
(I also put a tick in the "Read only recommended" box.

I click okay and another box comes up wanting me to re-enter my password,
which I do and click okay.

I then save the sheet.

Later I load the sheet again and the first thing that happens is I get a
"Password" dialogue box, whixh says "Enter password for write access, or
open read only", so Iclick on the "Read Only" button.

I can then delete and modity whatever, no problem, I want and save it right
on top of the original!

What am I doing wrong, please?
Jim Rech - 13 Oct 2007 16:04 GMT
>>I can then delete and modity whatever, no problem, I want

That part is expected.  This does not protect a sheet from editing.  Use
Tools, Protection, Protect Sheet for that.

>> and save it right on top of the original!

That's not what should happen or what happens to me.  After I click Read
Only to open the file it says "[Read-Only]" in the worksheet window's
caption.  And if I try to save it I cannot overwrite the original.  I have
to use another name or another location.

Signature

Jim

>I have tried saving an xls sheet under a different name using a password to
>stop others from changing the contents but I can't seem to get it to work.
[quoted text clipped - 18 lines]
>
> What am I doing wrong, please?
John Vanini - 13 Oct 2007 19:00 GMT
That's brilliant! It works beautifully! I don't understand why the other
system didn't work as that is what it seemed to imply - but it really
doesn't matter.

Thanks a lot, Jim, I can now password protect my spreadsheet and I'm very
grateful.

John

> <snip>
> Use Tools, Protection, Protect Sheet for that.
><snip> Jim
Gord Dibben - 13 Oct 2007 19:23 GMT
Just note that Excel's internal password protection is very weak and passwords
easily cracked.

Gord Dibben  MS Excel MVP

>That's brilliant! It works beautifully! I don't understand why the other
>system didn't work as that is what it seemed to imply - but it really
[quoted text clipped - 8 lines]
>> Use Tools, Protection, Protect Sheet for that.
>><snip> Jim
John Vanini - 14 Oct 2007 19:07 GMT
Oh dear, I didn't know that. I have produced a census in Excel, and wanted
to put it on the Internet but, obviously, I don't want anyone changing any
details.

I shall have to look for some other way.

Thanks to all for your help,

> Just note that Excel's internal password protection is very weak and
> passwords
> easily cracked.
>
> Gord Dibben  MS Excel MVP
JE McGimpsey - 13 Oct 2007 20:16 GMT
Be aware that XL's protection is worth it's weight in tissue paper for
true security:

   http://www.mcgimpsey.com/excel/removepwords.html

> Thanks a lot, Jim, I can now password protect my spreadsheet and I'm very
> grateful.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.