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...