Solved

Paste in Excel not working

Posted on 1998-07-04
8
2,904 Views
Last Modified: 2008-02-01
I am trying to copy & paste some data in Excel. When I go to paste it I get a msg stating
that "the data on the clipboard is not the same size and shape as on the clipboard and do
you want to paste anyway".
When I hit yes, it doesn't do any thing.
I looked at the choices for text on the clipboard and they are auto, text and OEM text.
Tried them all and none seem to work.

Help....
0
Comment
Question by:brianchess
8 Comments
 
LVL 3

Expert Comment

by:shalbe
Comment Utility
brianchess,

You need to select either a single cell or the exact same size and shape of cells as was originally selected for the copy operation. The simplest way is  to select a single cell before pasting.

In other words, if you copy an area 3 columns wide and 12 rows long, when you go to paste you have to select either a single cell or an area 3 columns X 12 rows before pasting.

Are you doing this ?

Let me know if this solves your problem so I can repost as an answer. If it is not the problem, let me know and I will look deeper.

Steve
0
 
LVL 4

Expert Comment

by:saar2
Comment Utility
shalbe,
Why do you post your answer as a comment?

Saar
0
 

Author Comment

by:brianchess
Comment Utility
I am doing only one colum of cells, as in the F colum.


I've done it on other machines.....
0
 

Expert Comment

by:wsanchez
Comment Utility
You might be copying a very large amount of data to the clipboard.  Try copying and pasting your column part by part.  I don't mean cell by cell because that would take a long time.  You could try copying and pasting half of your column first and then the other half.  If it still doesn't work, try dividing it again.  If that still doesn't work, then I'll think of another suggestion.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:brianchess
Comment Utility
Tried that.... still get the same prompt.
Would it be something in clipboard??

0
 

Expert Comment

by:grizzle053098
Comment Utility
Saar
The reason Shalbe posts the answer as a comment is because he is polite enough to allow other people to comment if neeeded without locking the question. Brianchess can decide if the answer fulfills all his requirements. It's not about grabbing the points it is about helping others.....
0
 
LVL 1

Expert Comment

by:CEBAKA
Comment Utility
When you have selected the data you want to past.

Right click your mouse and paste special.
0
 
LVL 1

Accepted Solution

by:
x30 earned 50 total points
Comment Utility
Some times if you want to paste (or embed) other thing from any other aplication like sound or graphics, you can not just simply copy and paste, you have to put an emebed statement in your cell, to acceses that information Try the fx EMBEBED=
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

How many times recently have you prepared a presentation or emailed a document to a client and you have found that they have older versions of MS Office and they can not open the file you have prepared.  Although most visitors to this site are exper…
This article will show you how to use shortcut menus in the Access run-time environment.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now