Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    = Causes Crash (97)

    Excel has just started crashing every time I press the equal sign to start a formula. This has happened to me before on other machines running different versions of Windows. Nothing easy fixes it. I end up having to reinstall office. All other programs work normally.

    Anyone have any suggestions?
    Ronny
    Ronny Richardson

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

    Re: = Causes Crash (97)

    Does it happen on all sheets, or just one particular sheet? Does it happen in a new workbook? If you select Run from the Windows Start menu and type:

    Excel /Automation

    Does it still happen? If the answer to the last question is yes, then the Excel program is corrupted, and the only fix is to reinstall.
    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Newcastle, New South Wales, Australia
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: = Causes Crash (97)

    This happens on one of my computers every so often. I've got no idea why. What I now do is to edit the registry. You need to know what you are doing before you edit the registry. I will give my way (from memory) but check it with someone else to make sure i haven't left anything out. (I'm in Win98)
    0. This method loses your toolbar buttons and special set-ups, so go into Excel and copy down anything you may need to know to re-create them.

    1. Go into RegEdit by clicking on Start Run and type in regedit

    2. Find the excel bit (then next step is to save it.) When you get into RegEdit, it looks a bit like an Explorer window with HKEYs on the left. One of them is HKEY_Current_Users. Click on that and it expands to show (among other things) SOFTWARE. Click on that and find MICROSOFT. Under that is OFFICE. Under that is EXCEL. (at least it is on my machine. yours may be a bit different.).

    3. Highlight the EXCEL and from the menu choose Registry | ExportRegistryFile. Give it a file name like Excel date. I put it on the desktop just to find it easily again. If all goes well you will just delete it. But if it goes haywire then you should be able to use the Registry | ImportRegistryFile to reload it.

    4. Then if you are REALLY SURE that you have backed this up, delete the EXCEL key by highlighting it and choosing delete from the Edit menu.

    5. Exit from RegEdit.

    I'm not sure whether you must re-boot at this stage, but it's often a good time to have a cup of coffee anyway.

    When you next go into Excel, the registry key will be re-created automatically. You will have lost any special set-ups you had. It is back at the 'out of the box' look. So there's a bit of work reconstructing your toolbars, buttons, etc. (The personal.xls file is untouched, so any macros are still there; they may just need to be applied.)

    Have I left anything vital out? Please check before you muck with RegEdit.
    Good Luck
    Ruth

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

    Re: = Causes Crash (97)

    If I am not mistaken, you can have Excel do this automatically:
    Start, Run
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver

    (quotes mandatory)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

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

    Re: = Causes Crash (97)

    Does that work on Excel 97?
    Legare Coleman

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: = Causes Crash (97)

    I'm glad to hear that I'm not alone. Registry problems make sense as a cause. I've reinstalled Excel but I've saved your post for the next time it happens, because there always seems to be a next time.

    Thanks
    Ronny
    Ronny Richardson

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

    Re: = Causes Crash (97)

    Yes, it should.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

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

    Re: = Causes Crash (97)

    Good, I thought that appeared in XL2K.
    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
  •