Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Location
    Colorado Springs, Colorado, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cut and Paste (2000)

    Oh great Excel gurus <img src=/S/please.gif border=0 alt=please width=31 height=23> <img src=/S/please.gif border=0 alt=please width=31 height=23>

    A friend of mine is having this problem in Excel. He'll cut and paste 20 different cells many times, but soon it just starts pasting 15 cells instead of 20.

    Anyone seen this strange behavior, and do you know of a solution?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Cut and Paste (2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Mike

    OK this is odd?!

    Can your friend tell us after how many pastes, the number goes down to 15?

    How much RAM and System Resources does your friend have on their system?

    Does the Paste operation seem to take longer each time he/she pastes?

    What is your friend copying and pasting, formulas, values in cells, formatted cells, cells with conditional formats, what I am trying to get at is how much work Excel needs to do for each paste operation and then figure out if it could be a resource issue?

    Does this happen in all workbooks, or a single one? Is a single one, its time to clean up the workbook, because its corrupted already. Let me know and I'll send you some ideas on how to do that.

    Does it happen on a single machine, or multiple? If single, maybe need to reinstall, something has gone bad...

    Are these 20 cells form a contiguous range, or are they from all over, specially multiple worksheets?

    OK I think I gave you enough questions for a two-please Smilie request... better use more next time... <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Jan 2003
    Location
    Colorado Springs, Colorado, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cut and Paste (2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

    The friend contacted me to let me know that he figured it out. It had to do with hidden cells/columns. <img src=/S/doh.gif border=0 alt=doh width=15 height=15> I think he was pasting and only seeing 15, the other 5 were being pasted into hidden cells/columns.

    Thanks for taking the time to reply to my post.

Posting Permissions

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