Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Ephrata, Washington, USA
    Thanked 0 Times in 0 Posts

    Can't close Excel with X (97 SR2)

    I have a user who can't close Excel unless he uses File, Exit. He can't use the x in the upper right corner. Any ideas? I re-installed Excel. No go.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Weert, Limburg, Netherlands
    Thanked 0 Times in 0 Posts

    Re: Can't close Excel with X (97 SR2)

    I have a default list of things to do with problems like this one:

    Try opening Excel without any addins or hidden workbooks:

    Start, Run,
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Automation

    Quotes mandatory, Note you may have to change the path.

    If your error disappears, there is either an add-in or a (hidden) workbook that is loaded upon XL's start, which bothers you.

    - Try locating the XLSTART directory, move everything from there.
    - In XL: Tools, Addins, note the ones checked and uncheck them one at the time, each time restarting XL
    - In XL, Tools, options, general. Check if a path is entered after "Alternate startup file location". Clear it.

    Another option is to open XL in Safe mode:

    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Safe

    Also, you might try:

    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver

    Yet another possible problem is a corruption of your toolbar customisation file. Locate all files with extension .xlb and rename the extension(s) to something like .old
    Now try and start XL again.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    Professional Office Developers Association

Posting Permissions

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