Link to home
Start Free TrialLog in
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...
Avatar of jerseysam
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
Avatar of Robert Reisig
Robert Reisig


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 -