Avatar of Robert Reisig
Robert Reisig
 asked on

Can't open password protected Excel spreadsheet when document is in a network share

The issue is: we have a user who was recently given a new Win7 desktop, with Office 2010. He routinely receives confidential Excel spreadsheets that are password protected; when he receives them via email he drops them into his home network share, on a Windows network server.

If he opens the document from the share, he's prompted for the password but after entering it the document doesn't open - only Excel opens, with no open documents visible.

If he has a spreadsheet already open, and opens the document, he enters the password and it works.

if he copies the spreadsheet to his desktop, it opens after entering the password. It's only an issue if opened from the share, and it's the first doc being opened in Excel.

Anyone have any ideas or comments? A very strange one...
Microsoft Excel

Avatar of undefined
Last Comment
Robert Reisig

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
jerseysam

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Rartemass

It could be opening minimised. On the View tab to the far right should be a Switch Windows button. If he clicks that and selects the file name does it display?
Robert Reisig

ASKER
Rartemass -

It seems that only Excel is opening. Switch Window doesn't show any options and virtually all other buttons on the ribbon are 'ghosted', as they would be if only Excel is open, w/out an open document in it.

Jerseysam -

Will do and done, and that's the work around we're using now. That seems to be OK for now but the matter is still open - very confusing.

Thanks to both of you for your input and suggestions! I'm going to close this for now -
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy