View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default open protected excel files

Did you successfully open the file?

If yes:
Is the SaveAs option greyed out for other workbooks?

If no:
I'd try closing the file and closing excel and then reopen excel in safe mode.

Close excel
windows start button|Run
type:
excel /safe
then use file|open
to open the file.

Is the SaveAs option still disabled?



Ammie Ho wrote:

I tried to open file it ask for password. I have to click on cancel, then go
to the file tab. But the save as is grayed out. What should I do?

P.S pls give me step by step direction. I can navigate through the program,
but not comfortable with it! Thanks;-)

"Ammie Ho" wrote:

I have been adding worksheet to my excel file. When I created it, i never
put a password on it. After I finish, I always save my file. Then I exit.
Before the file exit, it ask me again if I want to save. I say Okay. When I
come back toopen the file later, it as for a password. How do I unlock it.
or even open it as ready only to get my file?


--

Dave Peterson