Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Posts
    142
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Installed & won't work (2000)

    I recently formatted, then installed W9ndows 2000 Pro, then installed Office 2000 Pro.
    All bu tExcel will work. I get an error message syaing Excel has generated errors and
    will be shut down and the program must be re-started. Upon re-start I get the same
    message. I un-installed and re-installed with another version and got the same
    message. I/ve installed before with no problem like this ?????

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

    Re: Installed & won't work (2000)

    I recently had that problem. After spending two days on the phone with Dell Tech Support, the only way we could find to solve the problem was to reformat the drive, and reinstall W2K and then O2K.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Posts
    142
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Systematic Approach to Behavioral Problems in XL

    Safe mode worked, but this one appears to have been the fix.
    "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."
    Thanks for the quick response.
    So, what caused this to happen in the first place ?
    (Rhetorical Q, now that its fixed no response is necessary)
    Thanks again.

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

    Re: Systematic Approach to Behavioral Problems in XL

    XL just has a reputation of corrupting this file, I guess it is just one of those things.

    It seems this was improved in Office XP.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Etobicoke, Ontario, Canada
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Systematic Approach to Behavioral Problems in XL

    I too am having Excel start-up problems, all of a sudden.

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

    BAM, Excel starts instantly!

    If I do a search for "XLSTART" I get:
    a folder named "XLSTART" located in Cocuments and SettingsDadApplication DataMicrosoftExcel
    a shortcut named "XLStart" located in Cocuments and SettingsDadApplication DataMicrosoftOfficeRecent
    a folder named "XLStart" located in C:Program FilesMicrosoft OfficeOffice

    I don't know what you mean by "Try locating the XLSTART directory, move everything from there." Which directory? Move what? To where?

    In XL: Tools, Addins "DVZXLAddin" and "Small Business Financial Manager" were both checked and unchecking them one at a time, each time restarting XL made no difference.

    In XL, Tools, Options, General no alternate startup file location was indicated.

    Help! <img src=/S/help.gif border=0 alt=help width=23 height=15>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Systematic Approach to Behavioral Problems in XL

    Your personal XLSTART is the first one you mention:
    Cocuments and SettingsDadApplication DataMicrosoftExcel
    Try moving *all* files from this folder to a temporary other location, for instance your My Documents folder. Then restart Excel to see if the problems have gone away.

    (The second item you mention is only a shortcut; the third one is present for historical reasons, it is not used.)

  7. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Systematic Approach to Behavioral Problems in

    >a folder named "XLSTART" located in Cocuments and SettingsDadApplication DataMicrosoftExcel
    This is what is commonly referred to as "the XLSTART directory". Problems tend to arise when something defective is here.

    >a shortcut named "XLStart" located in Cocuments and SettingsDadApplication DataMicrosoftOfficeRecent
    This is of no practical interest.

    >a folder named "XLStart" located in C:Program FilesMicrosoft OfficeOffice
    There raerly, if ever, is anything in this directory. It is always good, nonetheless, to check it.
    Gre

  8. #8
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Etobicoke, Ontario, Canada
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Systematic Approach to Behavioral Problems in

    OK, so at the location "Cocuments and SettingsDadApplication DataMicrosoftExcel" there is a single file named "Excel.xlb" and a folder named XLSTART with nothing in it. Now what? (Sorry to be such a doofus!) <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Systematic Approach to Behavioral Problems in

    Move the Excel.xlb file to another location, for example My Documents, then start Excel to see if it works OK now.

  10. #10
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Etobicoke, Ontario, Canada
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Systematic Approach to Behavioral Problems in

    Hans, that seems to have fixed it! I don't understand, but I'm not sure if I need to or want to! <VBG>

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

  11. #11
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Systematic Approach to Behavioral Problems in

    Excel.xlb contains all your default settings and customisations. Sometimes it becomes corrupt. HTH
    Gre

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Systematic Approach to Behavioral Problems in

    Fine! As unkamunka remarked, the excel.xlb file sometimes becomes corrupt. You don't need the one you moved any more, you can delete it now. If necessary, Excel will automatically create a new one in the original location.

  13. #13
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Systematic Approach to Behavioral Problems in

    Since the XLB file contains customization and may become corrupt, I will periodically save a copy of it and if it goes bad just delete the current and use the backup. Also some VB programmers get "lazy" and modify the menus and will "reset" them to the default (rather than "restoring" them) so it also helps with this to "restore" all the menu customizations.

    Steve

  14. #14
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Etobicoke, Ontario, Canada
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Systematic Approach to Behavioral Problems in

    Thanks again to all and three cheers to Woody! Hip, hip, Hooray! Hip, hip, Hooray! Hip, hip, Hooray! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

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

    Re: Systematic Approach to Behavioral Problems in XL

    Just to set things a bit straighter:

    The first XLSTART folder you mention is your "personal" one, it is only used when you are logged on. When another user logs on, Excel will use his/her own folder.
    The second XLSTART folder (the one below the program files folder) is a folder that (from XL2000 and up) is normally not there, but can be created manually. This folder will be checked by Excel regardless of what user is logged on.

    This means that one has in fact a personal and a general xlstart, both folders are checked by excel at startup and ALL files from them are loaded, even if they are no Excel file at all (causing error messages).

    The Excel.xlb file ONLY contains menu- and toolbar customizations.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Page 1 of 2 12 LastLast

Posting Permissions

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