TECH CORNER

Bite Into Technology

Excel 2007 double click won’t open – Fix It

If you are a user of  Microsoft Excel 2007 , then you definitely would have come across the following problem:

When we try to open an Excel spreadsheet file  by double clicking it from explore or any location, only Excel program would be opened, but  not the worksheet. Sometimes worksheet may popup, once we try to minimize the launched Excel. Other times, no amount of clicking will get Worksheet open.

Excel may  load the worksheet document properly if We open it from within the program or by Right click->Open.

Here I give some solutions that I came across, When I faced the same problem:

1)First I tried the Microsoft support solution:

a)In Microsoft Office Excel 2007, click the Microsoft Office                            Button, and then click  Excel Options.

b)Click Advanced, and then click to clear the Ignore other                           applications check box in the General area.

c)Click OK.

For earlier version(2003):

a)In Microsoft Office Excel 2003 or earlier versions of Excel                              click Options, on the Toolsmenu.

b)Click the General tab.

c)Click to clear the Ignore other applications check box, and then            click OK.

It may work after trying this.

2)It may be due to a missing plug-in. so download andinstall it from following location: http://www.office-backup.com/download.html

3)It may be due a virus called MSblast.MSblast was not a mail-virus. MSblast could infect your PC by just being online, if you don’t have a firewall or a router with built-in firewall.
Broken file associations are not typical for MSblast virus, but it might be some other malware. If everything goes right, then try the above step again.

4) Another solution but is work around : Open Excel 2007, open the spreadsheet you are having problems with, click on the “View” tab, click on “Arrange all” button, make sure that “Tiled” is checked and click ok. You must save the worksheet to be able to view it again.
This is only a work around, but at least there is something.

Definitely I will get back to you, if i see more solutions to this problem

continued……………..


July 11, 2009 - Posted by increa | Interesting | | 2 Comments

2 Comments »

  1. you hit the nail right on the head. Just hung up with MS support and then was going to post the solution and found your site.

    Thank you.

    Comment by Bryan Lowrie | August 4, 2009 | Reply

  2. Likely to be caused by Excel having DDE enabled (Excel’s standard way of opening files), the fact that Excel is a multi-threaded application and the presence of certain Add-Ins.

    Have same problem with one Add-In: with Add-In off, file opens immediately, with Add-In on, I need to open via File-Open or double click again with Excel open.

    If I turn off DDE, it opens immediately but then I have a separate Excel task in memory for each workbook (with DDE, only a single task).

    My assumption is that while Excel is booting the Add-In(s), a timeout occurs on the (DDE) thread that opens the workbook and the workbook does not open. A grey page and no blank workbook is caused by this: http://office.microsoft.com/en-us/excel/HA101580301033.aspx

    Dutch

    Comment by dutchgemini | August 11, 2009 | Reply


Leave a comment