+ Reply to Thread
Results 1 to 4 of 4

error while pasting the data

  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    san diego,california
    MS-Off Ver
    Excel 2003
    Posts
    23

    error while pasting the data

    i get the error "data on the clipboard is not same size and shape as the selected area,do you want to paste it anyway"
    and is i click yes i get an extra columns with some weird data
    could any one please let me know how i could remove this or set the size or do anything to get my data pasted properly.......please help.......
    its urgent...:-(
    Last edited by rds207; 08-18-2009 at 01:56 PM.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: error while pasting the data

    For Excel to paste properly the Copy Area and the Paste Area must be exactly the same size.

    Your error is caused by either selecting fewer or more cells in the paste area than are in the copy area.

    The easiest way around this is to select a single cell when pasting and Excel will automatically determine the size of the paste area. You'll never see the issue again when using this approach.

  3. #3
    Registered User
    Join Date
    08-04-2009
    Location
    san diego,california
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: error while pasting the data

    thank you for the reply , i did the same , i mean selected with single cell and copied but i get this weird stuff below every column......please help....


    t.M6290AKPVZL3300.all.med.txt">70</A>, <A HRef="File://\\fosters\builds440\TEST\M6290AKPVZL3300\build\ms\lintPF\M6290AKPVZL3300\SUboot.M6290AKPVZL3300.all.med.txt">74</A> drivers\boot,romboot\oemsbl etc etc

  4. #4
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: error while pasting the data

    Are the source cells in the same or another workbook? Does it happen with other workbooks using the same data source?

    Possibly you may need to clear the clipboard before copying and pasting.

    To clear the contents of the Windows XP Clipboard Viewer follow these steps:
    1. Click the Windows Start button.
    2. Click the Run icon, which will open the Run box.
    3. In the text box, type the word Clipbrd, and click the OK button.
    4. The Clipboard will show your recent copy & pastes.
    5. To clear the contents, click the word Edit in the top menu bar of the Clipboard Viewer window.
    6. On the dropdown menu, click the word Delete.
    7. A popup window will ask you you want to clear the contents of the Clipboard, and you can click the Yes button.
    8. Close the Clipbook Viewer Window to continue with your work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1