Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Excel Clipboard not Pasting All Data

This is a discussion on Excel Clipboard not Pasting All Data within the Excel Questions forums, part of the Question Forums category; Hi All MrExcel Users, Is the clipboard limited for pasting all data? Because I have copied a number of data ...

  1. #1
    Board Regular MrVillareal's Avatar
    Join Date
    Jun 2011
    Location
    Philippines
    Posts
    497

    Default Excel Clipboard not Pasting All Data

    Hi All MrExcel Users,

    Is the clipboard limited for pasting all data? Because I have copied a number of data but is not pasting all in there.

    Thank you for your help.

    Best regards,
    Marvin

  2. #2
    MrExcel MVP Jerry Sullivan's Avatar
    Join Date
    Mar 2010
    Location
    San Diego, California
    Posts
    6,953

    Default Re: Excel Clipboard not Pasting All Data

    Hi Marvin,

    I'm not aware of any limit- you should be able to copy all cells of a worksheet to another worksheet.

    Is it possible that you have some rows or columns hidden or filtered and that data that didn't seem to get pasted is getting pasted to those hidden cells?
    Using Excel 2013

  3. #3
    Board Regular MrVillareal's Avatar
    Join Date
    Jun 2011
    Location
    Philippines
    Posts
    497

    Default Re: Excel Clipboard not Pasting All Data

    Hi Jerry,

    Thanks for your time..No hidden rows actually but I found out that its only limited up to 24 copies Im using excel 2010. And Im not sure as to total capacity. Because when you exceed that capacity it will not paste those data that exceed that capacity and you have to copy those data that were not pasted. I dont know how to deal with that situation. Thats why I have to count my copied data and still depends on the amount of capacity I already consumed.

    Is there any way to solved this?

    Best regards,
    Marvin

  4. #4
    MrExcel MVP Jerry Sullivan's Avatar
    Join Date
    Mar 2010
    Location
    San Diego, California
    Posts
    6,953

    Default Re: Excel Clipboard not Pasting All Data

    Hi Marvin,
    I don't have Excel 2010, so I'm afraid I'm not able to help you.
    Are you saying that Excel 2010 allows you to have 24 separate clipboards saved at the same time?
    Using Excel 2013

  5. #5
    Board Regular MrVillareal's Avatar
    Join Date
    Jun 2011
    Location
    Philippines
    Posts
    497

    Default Re: Excel Clipboard not Pasting All Data

    something when you copy it will inform you on the bottom right i.e "10 of 24". So it means the number of items in the clipboard is 10. So if you are copying more than 24 sheets to put it in one sheet it will just simply takes time.

    I dont know how to deal with this limitation.

  6. #6
    Board Regular MrVillareal's Avatar
    Join Date
    Jun 2011
    Location
    Philippines
    Posts
    497

    Default Re: Excel Clipboard not Pasting All Data

    and I think clipboard has this total capacity that when you exceed even if you just copy one sheet it will not pasted all. But Im not sure about that total capacity.

  7. #7
    MrExcel MVP Jerry Sullivan's Avatar
    Join Date
    Mar 2010
    Location
    San Diego, California
    Posts
    6,953

    Default Re: Excel Clipboard not Pasting All Data

    This site explains how to clear all or selected items from the clipboard.

    http://www.dummies.com/how-to/conten...xcel-2010.html

    Would that work for you?
    You can't possibly need more than 24 items saved at the same time!
    Using Excel 2013

  8. #8
    Board Regular MrVillareal's Avatar
    Join Date
    Jun 2011
    Location
    Philippines
    Posts
    497

    Default Re: Excel Clipboard not Pasting All Data

    Thanks for providing the link Jerry but my concern actually is that I am not able to paste all my data because maybe the capacity of my data exceed the capacity required by clipboard that's why I cannot paste at one time but more than one time..is there anyway to solved this? is it the settings? the problem is that I dont know the answer for this.ehe.. Any way I really appreciate your help Thank you Jerry.

  9. #9
    MrExcel MVP Jerry Sullivan's Avatar
    Join Date
    Mar 2010
    Location
    San Diego, California
    Posts
    6,953

    Default Re: Excel Clipboard not Pasting All Data

    Are you saying that you are trying to paste multiple items from the clipboard at the same time? For example, are you trying to "Copy" the data from 24 or more worksheets and then paste them onto a single worksheet?

    Just guessing since I don't have xl2010...but I don't think that is the intent of the multiple item clipboard. I expect it would be to allow you to have more than one storage space, but that you would still need to paste one item at a time.

    If you are trying to consolidate data from many worksheets into one, there are many examples on this site of how to do that with VBA. It's one of the most asked questions.
    Using Excel 2013

  10. #10
    Board Regular MrVillareal's Avatar
    Join Date
    Jun 2011
    Location
    Philippines
    Posts
    497

    Default Re: Excel Clipboard not Pasting All Data

    Oh yeah VBA can help me with that please give me the code..Because actually each day I create a debit notes as shown below. So each day I have sequenced for each debit note and at the end of the month I want to copy all these sheets into one sheet for my pivot table.

    Excel 2010
    ABCDE
    10DN No.:DN26102011-33Date:26-Oct-2011
    11
    12
    13Business Unit CodeBusiness UnitInvoice NumberCheck NumberCheck Amount (SAR)
    1413185Stockyard-Central Region CenterSB000322114965 1,500.00
    1513322Dammam Mega CenterSB000320214965 1,970.00
    1613344Hafr Al Batin Sinaiyah  CenterSB000316214965 1,560.00
    1713321Hafr Al Batin CenterSB000316114965 2,420.00
    1813411Airport Road,Madinah Munawarah ( PaSB000316314965 3,100.00
    1913176Al Kharj Square 1SpSB000315214965 760.00
    2013321Hafr Al Batin CenterSB000315014965 740.00
    2113321Hafr Al Batin CenterSB000314914965 740.00

    DN26102011-33




Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com