Word & Excel require two password entries before opening

Microsoft Office 2010 professional
August 2, 2013 at 07:04:47
Specs: Windows XP
One of our users came to me to say that consistently, for the last three or so months, several of our password protected Word docs and Excel workbooks have required her to put in the password twice before they'll open. I've tried ruling out user error like wrong password or double clicking the links or clicking twice when it should be once and I just see nothing that she's doing incorrectly.

When this first started, we had a large file accidently deleted and pulled back from a system backup. Could this possibly have any bearing on why Access wants the password twice?

See More: Word & Excel require two password entries before opening

August 2, 2013 at 07:30:13
I believe there are separate password prompts that can be set to 1) open the file in the first place, then 2) edit the file (otherwise it opens as Read-Only).

Maybe someone changed options on those files so one is for opening and one is for editing.....?


Report •

August 2, 2013 at 07:45:16
You might try turning the preview option off, and seeing if that fixes it.

:: mike

Report •

August 2, 2013 at 08:15:39
@ GingerLeake:

Just looking for a little clarification.

First you said: "several of our password protected Word docs and Excel workbooks "

Then you asked: "Could this possibly have any bearing on why Access wants the password twice?"

So is it just Word and Excel or all MS Office applications that are asking for the password twice?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

August 2, 2013 at 08:45:08
Analyst: I'll have to get onto her computer to look at her options because I don't see anything like that on the actual workbook.

Mike: I'm not sure what you mean by 'preview' option. I went through Options but don't see what this could mean.

Dad! No, no, not Access. Consider that a Freudian slip, I should be working on the database rather than researching this problem in Exscel (which I have never seen so don't know what she's doing when she gets the problem) but she's a manager's manager, so I have to look into it.

She mentioned Word docs too, but the Excel wb is what I am most familiar with--I created them. As far as I know, it doesn't happen to anyone else either so perhaps her own settings?

A little info on the wbs she's complaining about....it's a workbook with multiple pages which includes charts and raw data which is called by links to other workbooks.....OMG, I think I just figured it out!!!

The master workbook (hers/the manager) is fed by links from other workbooks. The person that usually opens all the wbs so they refresh each other has been out after an auto accident so if her (the employee that opens the wbs) backup is not here to open them, when the manager does, she's getting the multiple password request because ALL of the workbooks are pw protected.

I think that's it, I HOPE that's it! If it's not, I'll be back looking for more ideas!

Thanks for your input, guys!

Report •

August 2, 2013 at 08:56:13
I got excited for nuthin'.

But she showed me what it's doing anyway.

She closed all Excel documents, went into our shared folder and opened the wb called Master Data. The Excel window opened with a password prompt that said opening a copy of Master Data. She put in the password and the next prompt appeared, stating it was opening Master Data (no 'copy of' this time.) When she put in the password again, the wb opened....just one copy that stated it was Master Data.

Any ideas?

Report •

August 9, 2013 at 08:43:18
Maybe the document is linking with a database that (now) requires authentication..... ?

Can you provide (properly redacted) screenshots?


Report •

August 9, 2013 at 13:37:03
Linked workbooks could definitely be causing this issue. Have you checked out these links:




Report •

Ask Question