Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



Unable To Paste

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I am copying verbiage from one document saved in Word 2003. Trying to paste into Word 2007 document. Actually even trying to copy and paste within 2007 documents does not work.
Ctrl C or any variation to get a copy, then Ctrl V or any variation to paste = Nothing.
Clipboard is turned on.
I get an error message "Item not collected. Format not supported by Office Clipboard" when I do a Ctrl C
I understand what it is saying but why. Can I get around this?

Brian

View Answers     

Similar Excel Tutorials

Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forenames, surnames and ages. As ...
Copy one range and paste in another range
Below is a macro, just copy and paste it into a module in your workbook and go from there.This macro uses message b ...
List All Defined Names and Values in the Worksheet in Excel
Quickly list all Defined Names and their Values in the worksheet without using a macro. This allows you to view an ...
Quickly Switch the Columns and Rows of a Data Set in Excel
How to switch a data set in Excel so that the columns become rows and the rows become columns. This will save you ...
Make Negative Numbers Positive in Excel and Vice Versa
I will show you a few ways to change negative numbers to positive numbers and back again in Excel. Don't forget to ...
Insert Check Mark in Excel - 3 Ways - Incl. VBA and UDF
This tutorial goes beyond other simple check-mark tutorials. Here, I'll show you 3 methods to insert a check-mark i ...

Helpful Excel Macros

Save the Current Worksheet as a New Excel Workbook File
- This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to a
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume
Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
Replace Formulas with Values (For The Entire Workbook)
- This macro will convert every formula in an entire workbook into its respective value. This is basically a quick way to
Macro to add a New Line to Message Box Pop-up Windows in Excel
- This is a very simple Message Box, pop-up window, macro for Excel that illustrates how to put new lines, the same thi

Similar Topics







I have Excel 2007 SP2. When I try to copy a formula using Ctrl+C and paste using Ctrl+V, only the copied value is pasted. When I copy using Ctrl+C and paste using a right mouse click, it pastes correctly. Also, if I copy using Ctrl+C and drag to the cells I want to calculate, it pastes correctly.

If I copy using Ctrl+C in C1 (having divided A1 by B1) and then select cells C2-C3 and try to paste using Ctrl+V, I get a message that the data on the clipboard is not the same size and shape as the selected area, do you want to paste the data anyway? I say OK and the column headings change from letters to numbers!

I've tried rebooting, repair, reinstallation of Excel, all to no avail. What gives?


Hi
I have a sporadic problem were excel will not collect items to the clipboard same in word. I can copy and paste singly but cant copy multiple items to the clipboard to paste singly. this also happens in word at the same time but onenote which was installed seperately can copy to the clipboard normally. office 2007 windows 7

thanks
steve


In Microsoft Excel, I used to be able to select a group of cells and then paste it into Word as a Picture (both windows metafile and enhanced metafile). But now when I do this, it simply pastes nothing.

If I just do a regular paste (using ctrl+v) it will paste the cells as per normal, so I know that my clipboard is working. And mysteriously, if I log in to an administrator account (on the same computer) instead of a user privileges restricted one, I am able to paste cells as Picture in Word perfectly.

Does anybody know why this is the case? I'm using Office 2003 with the 2007 comptaiblity program installed and running Win Xp Pro SP3.


Hi,

I have excel 2007 and on any cell I copy either Ctrl C or Copy from the lsiting then move to any other cell I can do Ctrl V or Paste once, then the cell contents disappear from the clipboard and the Paste option is now gray. I tried F2, SHift - Home and then Ctrl C, followed by multiple Ctrl V's and it works fine, but I should not have to do this every time. all help appreciated


For some reason I cannot copy from one workbook to another. My typical
method for copying is to hit Ctrl+C, switch workbooks, then hit Ctrl+V
although attempts to use the toolbar and right-clicking don't seem to
work either.

The copy function works fine. I get the "marching ants" to indicate
the area I've selected to copy. However, when I switch to another
workbook, the clipboard seems to empty itself so I cannot paste what
I've copied. I can copy/paste within the same workbook without a
problem. This only occurs when I want to copy from one workbook to
another.

Any help would be appreciated.

Mike.




Hi all,

Anyone know if, in Excel (or in Windows in general, for that matter), there's a way to dump the clipboard AFTER AN INITIAL paste (like a "paste once" only kinda thing)? Say, I copy the word "cool" from some non-office App, then paste it in a WS. After successfully pasting this, I need an empty clipboard... It appears I ask the impossible.

Thanx,
Frith

CP Link (per forum rules):
http://www.mrexcel.com/forum/showthread.php?p=2732988


When I use Ctrl-y to repeatedly paste, it, strangely, only works one time.

For example, if I want to paste six times, I copy and paste the first time. Then, I use Ctrl-y to paste the second time. The third time, Ctrl-y would not work. I have to left-click and choose "paste". After that, Ctrl-y would work again. Right after that, the fifth time, Ctrl-y would not work. I have to do a left-click and choose "paste". The sixth time, Ctrl-y would work again.

Ctrl-y only works every other time, after I do a paste from menu.

Any idea what is going on? This is Excel 2007 on Window 7 ultimate.


Hi all,

I do a lot of copying/pasting in excel. This gets 'tossed' into the
Clipboard and somehow gets full. When this happens, I'm unable to copy/paste.
I close excel completely and am still unable to copy/paste. The weird thing
is that it affects other programs, not just Office. Is there a way to clear
the clipboard? Or is there something else that could be the cause? Thanks
for any feedback.

Sean

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200604/1



Hi,
Just installed Office 2010.
When I press PrintScrn or ALT+PrintScrn >> move to an open WB and try to Paste the picture (which is, probably, located in the Comp. Clipboard) into whatever sheet -
I get this error:"Microsoft Excel cannot paste the data".
Pasting into a "Word" Document works like charm.
More than that - when I copy that pasted picture (from inside the document) it "agrees" to be pasted onto the WB Sheet.
Does anybody any clue ?
I am aware that the 2010 is a fresh beta version, "still warm from the oven", but maybe one of you faces a similar problem in one of the previous versions.
Thanks,
Elm


I copy a lot of screen shots on the internet (Firefox) in order to crop them and use them in Excel. ONLY LAST WEEK did I start having this problem. I use the ALT+PRT SCR option to select what's on one monitor (I have dual) and then usually have no problem pasting into Excel. All of a sudden last week I started getting an error message "Microsoft Office Excel cannot paste the data."

I tried clearing out the clipboard in Excel and the ALT+PRT SCR option will either show a black image in the clipboard, or the clipboard will show "item not collected."

Why is this happening just now? I've been running 2007 for more than 6 months...never had a problem until now.




Apologies if this has been asked before and it can't be done, but, I'm trying to automate the following (I'm not a great VBA user, I'm afraid)

Step One
Copy item 1 from Outlook email to MS clipboard
Copy item 2 from Outlook email to MS clipboard
Copy item 3 from Outlook email to MS clipboard
Copy item 4 from Outlook email to MS clipboard
Copy item 5 from Outlook email to MS clipboard

Step Two
Paste Item 1 into selected cell (this varies with each running of the script and will be manually selected)
Paste Item 2 into Cell one to the right of the above
Paste Item 3 into Cell one to the right of the above
Paste Item 4 into Cell one to the right of the above
Paste Item 5 into Cell one to the right of the above
Clear clipboard

If I record it as a macro the script simply pastes the text as it was initially recorded rather than the current contents of the clipboard, which changes each time.
I have to do this 500 times

To do it manually requires approximately 30 mouse and keyboard actions and takes me nearly 2 days to complete. Clearly any automation I can incorporate will help greatly.
I expect to have to carry out step one manually, but if anyone can help with part two you'll earn my eternal gratitude.

Cheers
Tom

Hi and thanks for all your help in advance.

I created a macro with CTRL-V shortcut to copy text from websites and PDF's and paste them directly into Excel without formatting - just as text. Here is the VBA script and it works perfectly;


Code:

Sub PasteWOFormatting()
'
' PasteWOFormatting Macro
' Press Ctrl+v to paste text into a cell without any formatting
'
' Keyboard Shortcut: Ctrl+v
'
    ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
        False
End Sub


HOWEVER, whenever I copy and then try to paste something within Excel, I get;
'Runtime error 1004 - PasteSpecial Method of Worksheet class failed'

I think its got something to do with the clipboard and I have searched all over the web to try and find a solution but nothing works. I am not much good with VBA and would love a simple solution such as an IF THEN function in my VBA script or something else that allows me to copy within Excel as well.

Thank you so much for your time,


Hey all.

Excel 2010 is *extremely* annoying. In fact, I hate it.

Every time I try to CTRL+C to copy text from one spreadsheet and paste it into another spreadsheets column with CTRL+V, it's copying all the stupid formulas and junk with it, leaving the box with an N/A in it unless I manually move the mouse of to Paste and choose "Paste Values"

Who's the incredible genius at Microsoft that made copy formula the default paste? What a bunch of idiots.

How can I change the default paste function to be paste VALUES and not paste all the other junk?

Why do they mess with things like this, I just don't get it...

Any speedy answers would be great

Thanks in advance guys


-An Excel 2010 hater.


Hi and thanks for all your help in advance.

I created a macro with CTRL-V shortcut to copy text from websites and PDF's and paste them directly into Excel without formatting - just as text. Here is the VBA script and it works perfectly;


Sub PasteWOFormatting()
'
' PasteWOFormatting Macro
' Press Ctrl+v to paste text into a cell without any formatting
'
' Keyboard Shortcut: Ctrl+v
'
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
False
End Sub


HOWEVER, whenever I copy and then try to paste something within Excel, I get;
'Runtime error 1004 - PasteSpecial Method of Worksheet class failed'

I think its got something to do with the clipboard and I have searched all over the web to try and find a solution but nothing works. I am not much good with VBA and would love a simple solution such as an IF THEN function in my VBA script or something else that allows me to copy within Excel as well.

Thank you so much for your time,


I want to programmatically copy three ranges from one spreadsheet and paste those ranges into the same cell addresses of another spreadsheet. The code for copying the ranges looks like this:

Code:

  Sub Button256_Click()  
  Range("O16:W1289").Copy  
  Range("Z16:AG1289").Copy  
  Range("AK16:AR1289").Copy  
  End Sub  




This successfully puts the three ranges on the clipboard. My problem has been creating a macro on the spreadsheet to be pasted that would paste each range into the corresponding cells. Specifically, I don't know how to tell clipboard to paste this clipboard item here and that clipboard item there.

It is important that Range O16:W1289 of the copied spreadsheet be pasted in range O16:W1289 of the receiving spreadsheet. Thus, I need clipboard to be able to distinguish between the three. I was hoping that clipboard might do this by the order that items were copied, but I can't seem to get that working.

Here's a sample of what I have tried on the receiving spreadsheet:

Code:

  Sub Button255_Click()  
  Range("O16").Select  
  Selection.PasteSpecial Paste = xlPasteValues  
  End Sub  




I get a range error. I'm confident that the problem is that I'm not telling VBA which of the three items on the clipboard it should paste. How do I tell it that?

Thank you in advance.


Hi,

I am new to the forum.

I am trying to copy and paste a large workbook into a word document. In excel I choose the "fit to one page " selection, but when I copy and paste into word the pasted excel workbook is back to the original size.

How can I get it to be smaller once I paste it into word?

Any help would be greatly appreciated.

Thank you for your assistance in this matter.

AmyinMD


Hi,

I seem to have a problem. When I load Excel the Cut, Copy & Paste icons are greyed out, also if I right-click the three are greyed out there as well. I can still do Ctrl C & Ctrl V, but can't get Paste Special.

I've tried Detect & Repair but still no fix? I've downloaded spreadsheets from this forum today and it seems to be while doing this, could one of these had a macro to disable Cut, Copy & Paste?

I've got Norton with all the latest updates. Any ideas anybody?

Any help would be appreciated.




Hello,

I have an issue where I get an error message when trying to insert certain objects into PowerPoint presentations.

The error is ''The Server Application, Source File, Or Item Can't Be Found, Or Returned An Unknown Error. You May Need To Reinstall The Server Application''

If I go Insert > Object > File then it never works. If I try to copy and paste the item just using Ctrl + C & Ctrl + V then I can paste in Excel items to the power point however I cannot paste in other files into it. I get the error message displayed below. I have done everything recommended so far...

Error.png

Appreciate the help!

Thanks! :D

I have a word template that I open (as a new document) with excel VBA.
This template has bookmarks in it and I can copy and paste text or cell values from excel to the template to fill it out automatically. The one area I am having problems is in trying to create an email hyperlink in one of my bookmarks.

Does anybody have any suggestions?
Here is an example of the code I am using that does not work correctly:
Code:

Sub Hyperlink()
Dim wb As Excel.Workbook
Dim wdApp As Word.Application
Dim myDoc As Word.Document
Dim LinkName As String
Dim LinkAddress As String
Dim SPE, SCM, Purch, SQE, Vendor, Veri As Boolean

Set wb = ActiveWorkbook
Path = wb.Path & "\Test.dotm"
'On Error GoTo ErrorHandler

'Create a new Word Session
Set wdApp = CreateObject("Word.Application")
     
'Open document in word
Set myDoc = wdApp.Documents.Add(Path)

'Activate word and display document
  With wdApp
    .Visible = True
    .ActiveWindow.WindowState = 0
    .Activate
  End With

LinkName = "Name Here"
LinkAddress = "Email@Address.com"
  With myDoc.Bookmarks
    .Item("Bookmark2").Range.InsertBefore LinkName
    .Item("Bookmark2").Select
    With Selection
      .Hyperlinks.Add Anchor:=Selection.Range, Address:="Mailto:%20" & _
      LinkAddress, SubAddress:="", ScreenTip:="", TextToDisplay:=LinkName, Target:=""
    End With
  End With
End Sub


I have tried several variations on this and cannot seem to get it to work. I can paste the "LinkName" to the bookmark and select the bookmark just fine, but I cant get the hyperlink to attach.

Any help would be greatly appreciated.
Rick

P.S. I am using Office 2007 for this project. The Macro starts and runs in excel which then opens the word document. I wasn't sure if any of that was clear or not.


Hi peeps,

This problem seems to pop up every now and again and i can't seem to quite figure out why. I've done a fair bit of searching on the net too with not much success, actually no success.

I have an excel report which is formatted a certain way (merged cells, font sizes, numbers, highlighting, etc) and when i paste the data into another excel spreadsheet it loses its formatting completely. I've tried all the paste options (paste special values, paste formats, paste column widths the works). Even if i select the format painter tool on a cell in the source file and apply format to a cell in the destination sheet it doesnt take effect.

Strange thing is, this only happens when pasting into certain excel documents. If i paste the source data into a newly opened excel spreadsheet it works perfectly with a simple "Ctrl C" and "Ctrl V"

Anyone else had this issue? Its driving me mad!


We have a number of Excel users in our office who cannot copy and paste
between Excel workbooks. They can copy and paste between worksheets. When
you highlight the section to copy and then go to the new workbook both the
paste
and paste special are "grayed out". This is true whether you right-click the
mouse, go to the edit menu, or use control keys. This occurs with any data
type and the most simple workbooks. I have seen some suggestions here but
none have worked for this particular problem. I have reset the menus and
renamed the .xlb files and neither helps. You can open the clipboard and the
paste will work, but there is no paste special option. Any help would be
greatly appreciated. Thanks!




Is there a way to copy and paste a formula with some vba instead of the clipboard? Every once and awhile, I'll be trying to make duplicate copies of a page in a worksheet so that I have 50 - 100 pages of the same template. Sometimes the formulas copy/paste great with relative referencing. But sometimes, it will paste like it's an absolute reference. Plus, the copy/paste is reallllllly slow sometimes with a lot of formulas.

Any help or ideas?


I'm trying to write VB code to paste several Excel ranges into a Word
document, as required by my employer.

I'm able to do this satisfactorily using manual cut and paste (Office 2003),
but when I automate it, I get "Run-time error 438: object doesn't support
this method". I get this error whether I use Selection. or a variable Dim as
Excel.Range or Word.Range or Object. I also get the error regardless of the
type of paste I use. Pasted images aren't acceptable because the range may
span several pages.

Below is a code example. The errant command is flagged between '*****
comments. Otherwise, the code runs as designed. The GetWordApp is from a
previous post that I found useful (thanks!)

I would appreciate any help you can give.

Thanks,

Dave in Madison

Sub PrintToWordFile()

Const fname = "C:\Test.doc"
Const rname = "EntireBudget"

Dim a As Excel.Range ' print range
Dim g As Boolean ' gridlines flag
Dim o As Object ' word application
Dim w As Word.Document ' document within word application

g = ActiveWindow.DisplayGridlines
ActiveWindow.DisplayGridlines = False
Set a = Range(rname)
a.Copy

GetWordApp o
With o
.Visible = True
.Documents.Open Filename:=fname, ReadOnly:=False
Set w = .Documents(fname)
End With

'*****

a.PasteExcelTable _
LinkedToExcel:=False, _
WordFormatting:=False, _
RTF:=True

'*****

w.SaveAs "C:\Test.doc"
o.Application.Quit

ActiveWindow.DisplayGridlines = g
Set w = Nothing
Set o = Nothing
End Sub






Hello guys,

I'm trying to use a macros in VBA (excel 2010) to open a Word(2010) file, copy the content (with format) and paste on the body of a email in outlook(2010) but I can't figure it out how to use the paste special into the body of the email, so until now my code just keep the text in the clipboard, I hope someone can help me with this:



Please Login or Register  to view this content.


Best Regards,
Revs

Hello folks,

I can't believe I cannot find a solution to this problem somewhere on the Internet, but alas. I want to do something very simple:

1. Copy to the clipboard the contents of a cell in Excel, formatted as Currency.
2. Alt-Tab to a web browser
3. Paste the value WITH NO FORMATTING into an edit control.

For example, I copy the value 25000 (formatted to look like $25,000 by Excel) to the clipboard, then when I paste it into the browser edit field it appears with the dollar sign, commas, and some spaces thrown in for good measure.

Is there no way to make Excel copy only the value to the Windows clipboard with no formatting?

Yes, I know about Paste Special for pasting without the formatting. But I want to paste in an app that knows nothing of Paste Special.

Thanks in advance
adj