Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    New Cumberland, Pennsylvania, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    The Big 'X' (Excel 2000 sr1)

    All of a sudden, Excel has lost the X-out option in the upper right corner...it's greyed out. Any sheet open has it's "X" available, and they work. But the program itself can only be closed down from the File-Exit menu option. What did I inadvertently do?

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

    Re: The Big 'X' (Excel 2000 sr1)

    In mystery cases like these, I always post these things to try:

    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.

    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
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    New Cumberland, Pennsylvania, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: The Big 'X' (Excel 2000 sr1)

    Jan,

    Thank You! Yet another thing I learn through someone in this Lounge.

    It was an add-in put on by our LAN administrator, full of macros to run a peice of software I have no intention of touching anyway. Moved them to my "Useless and Annoying Files" folder, where they sit with several other assorted gems.

    Made notes of your advice, since I'm sure there'll be a next time...Thanks again.

  4. #4
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: The Big 'X' (Excel 2000 sr1)

    I think I understand what /automation does - but what does /regserver do? <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: The Big 'X' (Excel 2000 sr1)

    It resets all of Excel's Registry variables to their default settings.
    Legare Coleman

Posting Permissions

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