Opening password protected Excel 2007 documents by double clicking from My documents does not work u

Posted by erik-van-gorp on Super User See other posts from Super User or by erik-van-gorp
Published on 2010-05-18T08:09:42Z Indexed on 2010/05/18 8:11 UTC
Read the original article Hit count: 352

Filed under:

excel-2007

|

double-click

|

open

When all of the following conditions are true, excel will open (most of the time) but will not open the document itself. No error is displayed.

This only occurs with Excel files, Word and powerpoint do open perfectly.

Conditions :

OS is "Windows 7 Professional 64-bit"
office is "Office 2007 Ultimate".
excel file is in .xls (2003 format)
excel file is password protected
excel file is in "My Documents" (or a subfolder of it)
file is double-clicked from explorer under Windows 7.

Following options do open the excel file as it should :

right click and selecting the (bold) open action
single click the file and pressing enter
moving the file to the desktop and double-click it.
non password protected files do open from the same directory.

Actions taken not resolving the problem: - reboot - repair office installation - system restore does not work because of Antivirus application installed (message from system restore, using "Symantec Internet Security 2010")

Anyone any idea ?

© Super User or respective owner

Related posts about excel-2007

Inserting (jpg) pic inside MS Excel 2007 cell

as seen on Super User - Search for 'Super User'
Is it possible to insert a jpg image INSIDE a cell .... or do cell ONLY excel alphaNum char (or ref) ? >>> More
Conditional formatting using cell styles in Excel 2007?

as seen on Super User - Search for 'Super User'
Excel 2007 has added support for cell styles, which I find very useful. I love it when I can change formatting in one place and the change propagates throughout the spreadsheet. I also love conditional formatting. Can the two be combined? Can I conditionally apply a cell style? >>> More
FileSystemWatcher.Changed fires immediately when Excel 2007 opens XLS file in compatibility mode

as seen on Stack Overflow - Search for 'Stack Overflow'
We use a FileSystemWatcher to monitor documents opened from our Document Management system, and if the user saves the document, we ask if they would also like them updated in our system. We have a problem with XLS files in Excel 2007 (have not verified that the problem does not exist in 2003, but… >>> More
How to use the autocomplete feature for VBA function in Excel 2007 with Excel Add-In

as seen on Super User - Search for 'Super User'
(cloning from question on SO) I created a function in VBA. I want Excel 2007 to show the Autocomplete when writing this function in the cell's Excel. Detail as How to use the autocomplete feature for VBA function in Excel 2007 with Excel Add-In (.xlam)? ps. In Excel 2010, the autocomplete works In… >>> More
Excel 2003 charts not looking right in 2007

as seen on Super User - Search for 'Super User'
I'm not exactly sure this goes here but I don't know where else to look for help. I have some Excel files containing charts made with Excel 2003. When I open the file in Excel 2007 and save it (non 2007) is messes up the charts. However, when in Excel 2007 and I Save as a .xlsx type the charts… >>> More

Related posts about double-click

ASP.Net double-click problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, having a slight problem with an ASP.net page of mine. If a user were to double click on a "submit" button it will write to the database twice (i.e. carry out the 'onclick' method on the imagebutton twice) How can I make it so that if a user clicks on the imagebutton, just the imagebutton… >>> More
Hotkey for double-click highlight?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working in Eclipse and find myself always replacing multiple copies of the same word, but I always have to take my hands off the keyboard and screen to get the mouse, hover over the word, double click to select, and then copy or rewrite the word. Is there any way I can just move the cursor inside… >>> More
Implementing the double-click event on Silverlight 4 Datagrid

as seen on Stack Overflow - Search for 'Stack Overflow'
Any good soul have an example of implementing the "Command Pattern" introduced by Prism on "Double-click event" of Silverlight 4.0 DataGrid. I did try the following: <data:DataGrid x:Name="dgUserRoles" AutoGenerateColumns="False" … >>> More
How to create a small box above selected text ( double click to select it )

as seen on Stack Overflow - Search for 'Stack Overflow'
I try to write a dictionary extension for Google Chrome. Now, I want to pop out a small box when I double click to select text . How can I implement it :) Or like this one ( Fastest Chrome ). They're written in javascript. Thanks so much ! >>> More
GDL Presents: Creative Sandbox | DoubleClick Rich Media

as seen on Google Code - Search for 'Google Code'
GDL Presents: Creative Sandbox | DoubleClick Rich Media Tune in to hear about three cool, new campaigns that use DoubleClick Rich Media, from the core creative teams at clickTag, Spinnaker and Grow Interactive in conversation with a DoubleClick Rich Media expert. They'll talk about how they pushed… >>> More