+ Reply to Thread
Results 1 to 4 of 4

Dbl Click xls file, Excel opens, but no file loaded

  1. #1
    Registered User
    Join Date
    08-28-2007
    Posts
    2

    Question Dbl Click xls file, Excel opens, but no file loaded

    Hi there~

    The behavior of Excel on my workstation has recently changed and I have no idea why.

    Typically, when browsing through folders, you double click on an .xls file and that worksheet is opened within Excel.

    Now, when I double click on an .xls file, Excel opens fine, but is empty - no worksheet.

    However, there is no problem opening any of the files from within an already-opened Excel.

    I can't see any macro or security settings that might cause this, nor do I get any error message. For that matter, I can't see any practical use for this behavior so I'm not sure it's even a configuration setting I inadvertently changed.

    I would very much appreciate any advice as to any potential causes.

    Excel version is 2003, sp2.

    Many thanks!

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Hi gglover,

    I'm wondering if somehow your file extension's (.xls) Open command is not working or congfigured probably. To check:

    1. Open Control Panel --> Folder Options --> File Types
    2. Scroll down to (or type) XLS
    3. Click 'Advanced'
    4. In the 'Actions' window, select 'Open' and click 'Edit'
    5. You should have the following settings:
    .....Action= &Open
    .....Application used to perform action= "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e
    .....Use DDE= checked
    .....DDE Message= [open("%1")]
    .....Application= Excel
    .....DDE Application not running = (blank)
    .....Topic= system

    If these are all correct in your system, we'll have to dig deeper.

    One other thing: Are you sure there isn't a macro, perhaps in your personal.xls file that is controlling Excel behavior in the Workbook_Open event - possibly hiding workbooks/sheets? It's a longshot, but needs to be asked.

  3. #3
    Registered User
    Join Date
    08-28-2007
    Posts
    2
    Hi there!

    Many thanks for your succinct file type suggestions. I did check it and my settings matched the ones you listed.

    I searched for "personal.xls", including system and hidden files, but it wasn't found.

    Is that filename a standard, or could it exist under a different name?

    I had looked into the Macro menu areas for clues. In the security area, the level was set at medium. I set it to "low" just to test and got an interesting result.

    Clicking on an .xls file now opens the file, then also immediately opens an error dialogue box. If there's a way here to show you a screen snap of the dialogue box, let me know and I'll do it; meanwhile, the message is essentially that Windows can't find the file - but it lists the correct path and filename, plus the thing displays in the background behind the error message.

    I subsequently set security from low back to medium, then medium high, then high - and now I get the same result regardless, on all the .xls files I've tried.

    I checked for macros and vbscript and wasn't able to find either.

    So I think you pointed me in the right direction - it must have something to do with securities or macros. Although I know better than to use the word "must"...let me rephrase: it "appears to me that..."

    So at this point, it looks like I can do what I need to do - I just have to deal with the popup message aggravation each time...

    I do appreciate your help, and if any additional thoughts come to mind, I'll gratefully accept!

    -Gary

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    The fact that you get a pop-up and/or error when macro security is set to low makes me think you might have an add-in trying to load, but it is failing.

    Check these areas:
    1. In Excel, Tools -> Add-Ins...
    .....Uncheck all of the add-ins that may be checked, close Excel then re-open. Do you get the pop-up/error message still? If not, re-check those add-ins one-by-one (each time closing/re-opening Excel) to see if one of them is causing the problem.

    2. In Explorer (Windows), check the folders:
    ..... C:\Documents and Settings\your_user_name\Application Data\Microsoft\Excel\XLSTART
    and
    ..... C:\Documents and Settings\your_user_name\Application Data\Microsoft\Addins

    If there are files located in either directory, move them to a new location and try starting Excel. If you can't find that folder, you may have to change your Folder Options settings in Explorer to show hidden files/folders. (Tools -> Folder Options -> View tab -> select 'Show hidden files and folders')

    Hopefully one of those methods will solve the problem for you. If not, let us know.
    Last edited by Paul; 08-31-2007 at 12:01 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1