Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Crashes when printing selected cells (EXCEL 2000 SR-1)

    EU REPORTING THAT WHEN SHE TRIES TO PRINT A BLOCK OF
    CELLS FROM EXCEL IT SOMETIMES CRASHES EXCEL. THE SAME
    CELLS DO NOT ALWAYS CRASH EXCEL. THE MESSAGE IS: WINDOWS
    HAS ENCOUNTERED AN ERROR AND MUST CLOSE EXCEL. THIS
    HAPPENS SEVERAL TIMES A DAY.

    Where do I start? I used the Detect & RepaiR function but
    it did not work.

    THANKS

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

    Re: Crashes when printing selected cells (EXCEL 2000 SR-1)

    Is this only happening on one workbook? If so, then there is a possibility that it is corruption in the worksheet. Try the following:

    1- Open the workbook and select Save As from the File menu. In the "Save as type" drop down list select "Web Page (*.htm, *.html)" as the type of file. Click OK to save the file.

    2- Shut down Excel and start it back up. Using File/Open open the HTML file that you just saved in step 1.

    3- Use File/Save As to save the file back as a normal Excel file.

    See if this file still causes the problem.

    Be sure to keep a copy of the original file as the above procedure may lose some formatting or other things.
    Legare Coleman

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

    Re: Crashes when printing selected cells (EXCEL 2000 SR-1)

    If Legare's suggestions don't help, you can try Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post> on the end user's login.

Posting Permissions

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