I recently noticed everytime I open a password protected file in Excel 2010 it prompts for a password for the original file and a password to open a seperate copy of the same file! If I want to open a password protected file called for example “Books.xlsx” the dialog box pops up to enter my password then another dialog box pops up asking me to enter password for “copy of Books.xlsx also (the copy of file is whatever name your original file name is with the words “copy of” in front) It happens on all my password protected files. This is rather new for me I have been password protecting files in Excel for the last four versions of office and have never seen this before. I think it is related to a new update or something because the same thing happens on my laptop. I am running Windows 7 and Office 2010 home and business on both computers. Please help! It kinda scary!:o:
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Password protected Excel file-promptTwice for password for Original & Copy
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Password protected Excel file-promptTwice for password for Original & Copy
- This topic has 13 replies, 9 voices, and was last updated 1 year, 3 months ago by
JBD.
Viewing 5 reply threadsAuthorReplies-
RetiredGeek
AskWoody_MVPMarch 9, 2011 at 7:57 pm #1270895Ande,
Did you make the copies and do the non-Copy named files have links into the Copy named files? If there are links between the two files that would explain why Excel is giving you the second password prompt when it opens the file to update the links. :cheers:
-
WSande99
AskWoody LoungerMarch 10, 2011 at 7:36 pm #1271216No I did not make the copy of the file ; they don’t exist as far as I know that is what I find so scary. The only file I see is the original file in my folder. The copy only shows up when I try to open the file . First it prompts for a password on the copy then it prompts for a password on the original. Also and when I save it only the original file is saved, I am not asked to save the copy it’s acts like a shadow. I did check for links as you suggested but there are none. You did give me an idea – Excel did crash a while ago and when I opened it back up it gave me a choice between versions so I saved the one I wanted and it all seemed okay. That was a few weeks ago. I just went into the control panel and ran the Microsoft office repair under add change programs to see if that would help but after I ran it and opened the file it still does the same thing. If you have anymore ideas they would be appreciated!
-
-
WSsdckapr
AskWoody LoungerMarch 12, 2011 at 7:07 am #1271424In older versions of XL (97-2003), there is a file – save as option to “always create a backup” of the file which this sounds like a little bit. In the older versions, you don’t get the prompt for a password for the copy, nor do I think it opens…
I don’t have XL2010: does it have this option and is it on? If it is on, is the backup being saved to a location that is an alternate startup location so that the backup is being opened as well?
Steve
-
WSande99
AskWoody LoungerMarch 13, 2011 at 2:30 pm #1271559This 2010 version of Office is new for me. I think there is that option I will look into and let you know Thanks for the suggestion! Okay I did find that option it was turned on and it gave me a location so I copied that path into windows explorer and opened it but it was empty I also turned autorecover off saved my porblem excel file and reoped with auto recover off it still does the same thing. I also get the occasioanl message that excel cannot open and it askes me if I want to diagnose which I reply yes but it says it cant fix the problem do you think I should uninstall excel and reinstall it?
-
WSsdckapr
AskWoody LoungerMarch 13, 2011 at 5:04 pm #1271566Does it happen on all files or only this one? If only this one, I would try recreating this one as it may be corrupt. If recreating, do not copy or move whole sheets, but you can try copying sections of a sheet. But be certain that you know all the interconnections and links to formulas to make sure it is recreated properly
Steve
-
-
-
WSbilliken
AskWoody LoungerApril 3, 2012 at 6:29 pm #1327370I know this is a year old but there was no solution posted so I will post one.
I believe the problem is the Preview Pane in Windows. When you click on the password protected file, Windows tries to show a preview of the file, can’t open it and it triggers the request for the password of a “Copy of X”. If you turn off the preview pane in the directory where the password protected file is, you should no longer have this problem. I was experiencing this and turning off the preview pane worked for me. I am using MS Office 2007 on a Windows 7 OS. -
WSNaveed Zafar
AskWoody LoungerJuly 24, 2015 at 10:07 am #1516682You are genius mate! thanks
I know this is a year old but there was no solution posted so I will post one.
I believe the problem is the Preview Pane in Windows. When you click on the password protected file, Windows tries to show a preview of the file, can’t open it and it triggers the request for the password of a “Copy of X”. If you turn off the preview pane in the directory where the password protected file is, you should no longer have this problem. I was experiencing this and turning off the preview pane worked for me. I am using MS Office 2007 on a Windows 7 OS. -
anonymous
Guest
-
-
WSbalajidasari
AskWoody Lounger -
WSbilliken
AskWoody Lounger
-
-
WSricna
AskWoody LoungerSeptember 6, 2013 at 2:52 am #1410488Hi All, I had the same problem for a long time now and finally got to see your discussion on this. thanks for the tip. Turning off the preview does work and my password protected file only opens the original file, rather than the copy file. However, I find that the preview panel is very useful for checking those files without password. Is there any way, to have the preview panel on and yet not have the problem of opening copy of protected files?
-
zeddy
AskWoody_MVPSeptember 8, 2013 at 4:14 am #1410753Hi ricna
The preview pane essentially opens a new instance of the Appliction, in order to ‘show’ the file.
You can quickly toggle the preview pane display ON/OFF with [Alt] P
Although you could have a routine which tells whether an Excel file is password-protected or not, it would be difficult to have this operate with the preview pane.zeddy
-
-
JBD
Guest
Viewing 5 reply threads - This topic has 13 replies, 9 voices, and was last updated 1 year, 3 months ago by
-

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Microsoft: Troubleshoot problems updating Windows
by
Alex5723
32 minutes ago -
Woman Files for Divorce After ChatGPT “Reads” Husband’s Coffee Cup
by
Alex5723
40 minutes ago -
Moving fwd, Win 11 Pro,, which is best? Lenovo refurb
by
Deo
47 minutes ago -
DBOS Advanced Network Analysis
by
Kathy Stevens
10 hours, 29 minutes ago -
Microsoft Edge Launching Automatically?
by
healeyinpa
54 minutes ago -
Google Chrome to block admin-level browser launches for better security
by
Alex5723
13 hours, 10 minutes ago -
iPhone SE2 Stolen Device Protection
by
Rick Corbett
5 hours, 25 minutes ago -
Some advice for managing my wireless internet gateway
by
LHiggins
1 hour, 6 minutes ago -
NO POWER IN KEYBOARD OR MOUSE
by
HE48AEEXX77WEN4Edbtm
7 hours, 22 minutes ago -
A CVE-MITRE-CISA-CNA Extravaganza
by
Nibbled To Death By Ducks
22 hours, 39 minutes ago -
Sometimes I wonder about these bots
by
Susan Bradley
18 hours, 56 minutes ago -
Does windows update component store “self heal”?
by
Mike Cross
8 hours, 59 minutes ago -
Windows 11 Insider Preview build 27858 released to Canary
by
joep517
1 day, 12 hours ago -
Pwn2Own Berlin 2025: Day One Results
by
Alex5723
1 day, 12 hours ago -
Windows 10 might repeatedly display the BitLocker recovery screen at startup
by
Susan Bradley
14 minutes ago -
Windows 11 Insider Preview Build 22631.5409 (23H2) released to Release Preview
by
joep517
1 day, 15 hours ago -
Windows 10 Build 19045.5912 (22H2) to Release Preview Channel
by
joep517
1 day, 15 hours ago -
Kevin Beaumont on Microsoft Recall
by
Susan Bradley
1 day, 3 hours ago -
The Surface Laptop Studio 2 is no longer being manufactured
by
Alex5723
1 day, 23 hours ago -
0Patch, where to begin
by
cassel23
1 day, 17 hours ago -
CFPB Quietly Kills Rule to Shield Americans From Data Brokers
by
Alex5723
2 days, 13 hours ago -
89 million Steam account details just got leaked,
by
Alex5723
2 days ago -
KB5058405: Linux – Windows dual boot SBAT bug, resolved with May 2025 update
by
Alex5723
2 days, 21 hours ago -
A Validation (were one needed) of Prudent Patching
by
Nibbled To Death By Ducks
2 days, 12 hours ago -
Master Patch Listing for May 13, 2025
by
Susan Bradley
1 day, 23 hours ago -
Installer program can’t read my registry
by
Peobody
16 hours, 32 minutes ago -
How to keep Outlook (new) in off position for Windows 11
by
EspressoWillie
2 days, 10 hours ago -
Intel : CVE-2024-45332, CVE-2024-43420, CVE-2025-20623
by
Alex5723
2 days, 17 hours ago -
False error message from eMClient
by
WSSebastian42
3 days, 8 hours ago -
Awoke to a rebooted Mac (crashed?)
by
rebop2020
3 days, 17 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.