Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Maximum Help Please!

    I have configured Excel to freeze as soon as it opens! Here's what I did: I am running Excel 2000 on Windows 2000. This morning I changed my default font, and set up my primary and additional default folders. I got a message that the font would take effect after I restarted Excel. Now, every time I start excel, it apparently tries to open every spreadsheet I've ever saved, and it freezes after opening 6 or so. Can anyone point me in the right direction? Do I need to hack the registry to stop this behavior? Maybe change the default folders that Excel looks in? (btw, this sure seems like dumb behaviour on the part of Excel. Am I missing something here?) Thanks any and all.

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Maximum Help Please!

    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q211/4/81.ASP>Q211481</A> gives the start-up switches for Excel 2000. Try starting it in safe mode and see what happens.

  3. #3
    New Lounger
    Join Date
    Mar 2001
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Maximum Help Please!

    Leif, Thanks for your suggestion. Opening it in safe mode didn't help, but I went into the registry at (from memory) HKCUOffice9.0ExcelOptions, and deleted the value for AltStartUp ... After that, I was able to open Excel normally (and Verdana is my new default font. Does this qualify as an "Excel Annoyance?"

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Maximum Help Please!

    Probably <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    I probably should have said that once in safe mode, you could have checked your settings in Tools | Options | General.
    There you my have found you had unintentionally added an entry to the alt-startup folder. It's certainly something I've done in my time...

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

    Re: Maximum Help Please!

    AltStartup is NOT the default folder whereworksheets will be saved. It is an alternate XLSTART folder, and if you point it to a directory, Excel will try to open every file in that directory just as it does for XLSTART. It is meant for companies where the workstations are on a LAN and they want some place to put common files with common macros and still be able to have personal macros in Personal.XLS in the XLSTART directory.
    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
  •