|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
07-22-2008, 12:09 PM
|
|||
|
|||
|
Excel 2007 - option to set password to open disabled?
My boss gave me an excel document with sensitive payroll information about all our employees in it. I want to password-protect the document so nobody else in the office can open/modify it.
For whatever reason, in the Save As dialog box undre General Options, the option to set a password for opening the document is disabled. Interestingly, the option for setting a password for modifying it is still there, but the one for opening the document is greyed out. Another interesting characteristic about the document is that the option to Protect Sheet is disabled (2 sheets in the workbook - both are disabled from protection). There are no macros defined in the workbook and I'm using Excel 2007. Any ideas greatly appreciated. 
|
|
#2
07-22-2008, 12:33 PM
|
||||
|
||||
|
Are you running windows vista? if so it may be that damned "Run this as administrator" setting, it could e that you don't have the rights to set a password before open.
__________________
Regards, Simon Please read this before cross posting! Please always give feedback...good or bad! Please take the time to read the Forum Rules before posting!
|
|
#3
07-22-2008, 03:27 PM
|
|||
|
|||
|
Thanks, I'm actually the administrator (and only user) defined on my Vista machine. This is also not a problem with other Excel files - seems to only apply to a handful of documents that my boss gave me.
Any other ideas appreciated...
|
|
#4
07-22-2008, 03:33 PM
|
||||
|
||||
|
Th permissions may have been set on the network before you got them, right click on the unopened file choose properties thyen the security tab, click advanced then owner and see if you can take ownership, all other permissions i.e read/write et. are done from there!
__________________
Regards, Simon Please read this before cross posting! Please always give feedback...good or bad! Please take the time to read the Forum Rules before posting!
|
|
#5
07-22-2008, 07:35 PM
|
|||
|
|||
|
Thanks. I thought of that too, but permissions were fine in right-click properties.
I noticed that I also couldn't change any of the properties (Office Button -> Prepare -> Properties). Turns out the files he sent me have been saved as "shared" workbooks. Not too familiar with these yet. I'm also not sure if this was an intentional move by my boss, or (more likely) he inadvertently saved them as such without realizing what the implications were. The permissions weren't set properly to block any users from viewing or modifying the documents, so in effect the only thing he's done is disable several of the core features that would otherwise be available in Excel. I don't think it was ever his intention to have multiple users working in the same document at the same time on the network (at least that's my interpretation of what the shared workbooks are). Now I gotta figure out how to undo the shared features.
|
|
#6
07-23-2008, 05:01 AM
|
||||
|
||||
|
Well spotted!, shared workbooks can simply be unshared then saved then reopened and all should be fine, sharing is found under the review tab!
__________________
Regards, Simon Please read this before cross posting! Please always give feedback...good or bad! Please take the time to read the Forum Rules before posting!
|
|
#7
07-23-2008, 05:03 AM
|
||||
|
||||
|
Thread moved to correct forum.
__________________
Regards, Simon Please read this before cross posting! Please always give feedback...good or bad! Please take the time to read the Forum Rules before posting!
|
|
#8
07-24-2008, 02:47 AM
|
|||
|
|||
|
Thanks for your help
|
|
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
