1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need excel help

Discussion in 'Tech Talk - Gadgets, Gizmos and Technology' started by Sandman, Mar 7, 2004.

  1. Mar 7, 2004 #1 of 12
    Sandman

    Sandman Godfather

    374
    0
    Sep 23, 2002
    Hope someone here can help me.
    I use Excel frequently during the day on an on & off basis, I keep my .XLS files in seperate folders pertaining to different clients. Until recently I could click on an xls file and excel would open and load the file, now when I click on the file excel opens but will not load the file, I tried the repair function included in Microsoft Office 2000 Pro, I have even deleted MSO and reinstalled it, but to no avail, All of the MS applications word, powerpoint, etc, function ok, just having a problem with excel, since I am using different folders for the files I can not set up a specific file location in options and have it work easily.

    Thanks
    Bob
     
  2. Mar 7, 2004 #2 of 12
    retiredTech

    retiredTech Icon

    654
    0
    Oct 27, 2003
    Have tried "right clicking" the file THEN choosing "open with" option?
     
  3. Mar 7, 2004 #3 of 12
    Sandman

    Sandman Godfather

    374
    0
    Sep 23, 2002
    Yea I tried that and everything else I can think of, I was thinking there was something embeeded in the files that was causing this so I copied some of the files and tried them on another puter and they work fine, this thing really has me bugged, one day when I went to open a file a box poped up and said something but it closed so fast I could not read it, and since then the trouble began, one thing I noticed is that before the problem I would get a breif message at the bottom of the screen saying "Requesting Virus Scan" well that don't happen anymore, I turned off the virus protection momentarily but that did nothing.

    Bob
     
  4. Mar 7, 2004 #4 of 12
    Mike123abc

    Mike123abc Hall Of Fame/Supporter DBSTalk Gold Club

    2,818
    0
    Jul 19, 2002
    Are you sure the file has the .xls extension on it still? It could have been renamed foo.xls.bar, Windows will hide the .bar, and excel will not open it. Try renaming the file with .xls or open a dos window and look at it.
     
  5. Mar 7, 2004 #5 of 12
    Sandman

    Sandman Godfather

    374
    0
    Sep 23, 2002
    Yes the .xls extension is still there, like I said the files open on other computers, just not on mine

    Bob
     
  6. Mar 7, 2004 #6 of 12
    Chris Blount

    Chris Blount Creator of DBSTalk Staff Member Administrator DBSTalk Gold Club

    17,308
    28
    Jun 22, 2001
    So what you are saying is that all xls files on your computer will not open?

    I have seen this problem and what was happening was that all files were starting up minimized with nothing on the Excel toolbar to access them.

    Try creating a new xls file. Click the icon shown below in the attached picture, then maximize the spreadsheet again.

    Close Excel and then try opening your files.

    I don't know if it will work but it's worth a shot.
     

    Attached Files:

  7. Mar 7, 2004 #7 of 12
    TBenning

    TBenning Cool Member

    14
    0
    Mar 7, 2004
    The File association for the .XLS filetype was messed-up.
    If using Windows 2000 or WindowsXP, fix it by using the following steps.

    1) Right-click on an excel file, Choose Open with, Browse for Excel and "Choose Set as Default".
    2) In any Explorer window, go to the Tools menu and Choose Folder Options.
    3) Click on FileTypes tab
    4) Scroll down to the .xls file type and Highlight it.
    5) Click on the Advanced button
    6) in the Actions box, click on Open, then Click Set as Default. (if it is not already default)
    7) Click Edit...
    8) Ensure that the path to Excel is correct, AND ensure there is a /E at the end of the path as in this example:
    "C:\Program Files\Microsoft Office\Office 10\EXCEL.EXE" /e
    9) Make Sure "Use DDE" is checked.
    10) DDE Message should read exactly as follows: [open("%1")]
    11) Application should read: Excel
    12) DDE Application not Running field should be blank
    13) Topic should read: system
    14) Click OK, OK, Close

    That should reset everything necessary to make it start for you.
     
  8. Mar 8, 2004 #8 of 12
    djlong

    djlong Hall Of Fame

    4,343
    57
    Jul 8, 2002
    New Hampshire
    There's another possibility.

    I have a computer that was infected with a virus that the anti-virus didn't entirely get rid of. When I double click on a TXT file, I get a "can't open" message. If I open Notepad and open the file from INSIDE Notepad, it opens fine.

    Try opening the file from inside Excel.

    What's happening is that someone at one point hijacked the association with a bunch of filetypes to put in their back door before actually running Notepad, word, excel, etc. I *think* my antivirus didn't remove it completely because I did NOT open TXT files with Word and the 'scrubber' was expecting Word for TXT files.

    Well, it got rid of the back door, but there's still something out there looking for it. Fortunately it doesn't allow it back in.
     
  9. Mar 8, 2004 #9 of 12
    Sandman

    Sandman Godfather

    374
    0
    Sep 23, 2002
    TBenning

    I followed what you posted, check all the steps and they were set correctly as you described, i closed the folder options and clicked on a .xls worksheet and it opened, but across the screen I am getting a message that windows cannnot find filename.xls, which is the file name I just opened. it is now opening the files but gives me this cannot find message although it has opened it. I have to click on the message to make it go away

    Thanks
    Bob
     
  10. TBenning

    TBenning Cool Member

    14
    0
    Mar 7, 2004
    SandMan,

    I'm sorry the last steps did not work correctly. It sounds like the Registry settings are not 100% correct. These can be regenerated by following the steps below. It is true this could have been damaged by an incomplete removal of a virus, but it was more likely caused by an Excel file with unusual file permissions being opened.

    To resolve this issue, follow these steps:
    Double-click My Computer.
    On the Tools menu, click Folder Options.
    Click the File Types tab.
    Under Registered file types, click XLS Microsoft Excel Worksheet, and then click Delete.
    Click Yes to the Are you sure you want to remove this file extension? message.
    Click OK to close the Folder Options dialog box.
    Click Start, and then click Run.
    In the Open box, type regedit, and then click OK.
    Locate the following registry key:
    HKEY_CURRENT_USER\Software\Microsoft\Office\9.0

    Right-click the Excel key, and then click Rename.
    Type OldExcel.
    Locate the following registry key:
    HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0

    Right-click the Excel key, and then click Rename.
    Type OldExcel.
    On the Registry menu, click Exit to quit Registry Editor.
    Start Excel, and then quit Excel.
    Double-click the Excel workbook icon (or right-click the Excel workbook icon, and then click Open) to open the file.
    In the Open With dialog box, click Microsoft Excel for Windows, and then click OK.
     
  11. Sandman

    Sandman Godfather

    374
    0
    Sep 23, 2002
    T Benning,
    That worked, I can never fully express my gratitude for you help, this will save me numerous mouse clicks during the course of the day, I really appreciate your assistance.

    Bob
     
  12. TBenning

    TBenning Cool Member

    14
    0
    Mar 7, 2004
    You are very welcome. I find it very annoying when the computer refuses to work as it should. I've been lurking around this forum for a year, but I finally decided to "join" so I could reply to your plea for help.
    For me, that is what the forums should be used for. Unfortunately too many people simply use this as a place to complain about E*, D*, and V*. I've chosen to spend more of my time elsewhere now as I don't find much use in countless threads begging for a new channel, a new software update, or a better upgrade deal for existing customers. How many threats of "I'm canceling because..." do we really need to read?
     

Share This Page