Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel crashing after pasting contents of cells (Office 2003SP2)

    Hi there,

    I have a bit of a curious one that I am hoping someone else may have some experience of...

    I have a user that is trying to copy some email addresses from an Excel sheet and then paste them into the To line of an Outlook (2003 SP2) new email. After copying the cells, she then tries to create the new message - Outlook gives her the egg timer, and after a couple of minutes excel crashes and tries to recover all open spreadsheets in the recovery window. Copying information from all other programs seems OK - its just Excel.

    Originally I thought that it may have been an issue as she was copying email addresses, but I have since tried to copy standard text in single and multiple cells and I see exactly the same results. If she has a new email open, the copy and paste happens without a hitch, so I have asked her to do this, but she has already forgotten twice and crashed herself out twice. Normally this wouldn't that much of a problem, but we use a document management system and I have to go through a huge rigmarole to restore the crashed files back to the DMS.

    Can anyone point me in the direction of a setting/file or anything else that may cause this problem?

    Thanks

    Alba

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

    Re: Excel crashing after pasting contents of cells (Office 2003SP2)

    I can't reproduce the problem, but then I don't use a DMS. Have you tried whether the error occurs outside the DMS?

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel crashing after pasting contents of cells (Office 2003SP2)

    I have configured the users machine to not use the DMS wihtin Excel but the problem still remained, and I have tested the same issue on a number of machines with the same DMS configured with the same files and have not been able to replicate the problem either. I'm guessing that building up a new profile for the user may be the next step..but she has 10s of Gigs worth of PST files stored in her My documents, and I'd rather find another solution that going down that route!

    Thanks!

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

    Re: Excel crashing after pasting contents of cells (Office 2003SP2)

    You might try Help | Detect and Repair from within one of the Office applications first.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel crashing after pasting contents of cells (Office 2003SP2)

    Tried that thanks - but the detect and repair comes up with nothing. It happens with all Excel files not just specific ones. I have tried another profile on the machine and this allows me to copy with Excel and not crash when I open a new email - so I guess I need to go down this route..

    Thanks for your help anyway!

    Alba

  6. #6
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel crashing after pasting contents of cells (Office 2003SP2)

    HI there,

    I am now truly stumped...

    I have rebuilt the users profile. All was working for a few days and then the problem returned. I then completely rebuilt the machine. Again all was working well, and then a few days later the problem reoccured. Can anyone think of anything that a user could do that might cause behaviour like this??

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

    Re: Excel crashing after pasting contents of cells (Office 2003SP2)

    You might try Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

    I found a suggestion to completely uninstall then reinstall the printers (see Copy/Paste to Outlook crashes Excel; ignore all the warnings and scroll down all the way to read the replies)

  8. #8
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel crashing after pasting contents of cells (Office 2003SP2)

    Thanks very much Hans!! It turns out than once I uninstalled the printer and driver for an HP 3700 colour printer that the error stopped..I'm trying to recreate the problem with other machines and the same printer so that I can be 100% certain, but that seems to have done the trick!

    Thanks again!

    Alba.

  9. #9
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel crashing after pasting contents of cells (Office 2003SP2)

    Hi all,

    Just in case any of you happen upon this problem yourself..it turns out that it is not just to do with the HP 3700 printer driver. I was unable to recreate the problem on other machines that had the same printer driver installed, but after going through a painstaking process of trial and error, have finally concluded that it is a combination of two factors:

    1) Having the HP 3700 printer driver installed and

    2) Having Adobe Acrobat 7.0 Standard installed.

    I can now happily recreate the problem over and over again!!

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

    Re: Excel crashing after pasting contents of cells (Office 2003SP2)

    Happily? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

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