Copy Paste in Excel 2007

  • Thread starter NoviceAccessUser-Melanie
  • Start date
N

NoviceAccessUser-Melanie

Up until today I was able to copy and paste a range of data from one
worksheet to another worksheet in a different file. Now whenever I try to
highlight a range, press Ctrl C , mouse over to the other worksheet, and do
Ctrl V or click on Paste,
the Range where I am copying into is blanked out. Is there a known bug in
Excel 2007 related to the Copy and Past functionality. I have been working
with old and new spreadsheets and never had this problem until today. Please
shed some light. Thank you.
 
L

Liliana

=?Utf-8?B?Tm92aWNlQWNjZXNzVXNlci1NZWxhbmll?=
Up until today I was able to copy and paste a range of data from one
worksheet to another worksheet in a different file. Now whenever I try
to highlight a range, press Ctrl C , mouse over to the other
worksheet, and do Ctrl V or click on Paste,
the Range where I am copying into is blanked out. Is there a known bug
in Excel 2007 related to the Copy and Past functionality. I have been
working with old and new spreadsheets and never had this problem until
today. Please shed some light. Thank you.

Did you try pasting to Word or Notepad to check whether it is Excel related
or some other problem? How about copy to Notepad then to Excel?
 
N

NoviceAccessUser-Melanie

It seems to be only Excel related. I even try creating a new Excel file and
it still doing the same. And it also happens to different ranges of data that
I copy.
 
L

Liliana

It may seem to be Excel related but it could be clipboard related.

Using WindowsXP? If so,
click 'start'
click 'run'
type clipbrd and press the Enter key.


Now try copying in Excel and check that each time it copies, the result
shows in the Clipboard window.


The following Example will help you search Microsoft Knowledgebase.

If you copy the line after this paragraph and paste it into your favourite
search engine is should produce all "cannot paste" references in Microsoft
Knowledgebase relating to Excel. Update "cannot paste" different key
phrases or words to get different results.

excel "cannot paste" site:microsoft.com/kb


You aim is to modify the search to minimise the references found. Possibly

XL2003 paste fails site:microsoft.com/kb

Or

XL2007 paste fails site:microsoft.com/kb


Note: If you just enter 'excel paste site:microsoft.com/kb' (without the
quotes) you will get 2680 references I am fairly sure you don't wish to
wade through that many!


HTH
--
Lil


=?Utf-8?B?Tm92aWNlQWNjZXNzVXNlci1NZWxhbmll?=
It seems to be only Excel related. I even try creating a new Excel
file and it still doing the same. And it also happens to different
ranges of data that I copy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top