Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    stopping excel from copying (Excel 2002 SP2)

    Hi,

    Is it possible to stop Excel after you have selected the copy command? I frequently work with very large data sets (over 20,000 rows and 100 columns. I filter this data then try and copy and paste the filtered data into a new spreadsheet. Unfortunately where I work I don't have the fastest processor and only 256 RAM, so frequently the copy process takes a long time. If I need to do something else there doesn't seem to be any way to cancel the copy other than ending Excel with task manager.

    Does anyone know if there is another way to stop a copy?

    Thanks.

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: stopping excel from copying (Excel 2002 SP2)

    have you tried Ctrl + Break ?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: stopping excel from copying (Excel 2002 SP2)

    No I haven't, but will try next time it happens. Thanks.

    I just tried to do a big copy like the ones that take forever, but for some reason everything copied quickly this time.

Posting Permissions

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