clipboard doesn't always save contents

[Keith G Hicks]

Is there a setting that lets Excel save clipboard contents until something
overwrites it? I'm on Excel 2003 and ever since I can remember when you
highlight a cell or a group of cells and then hit CTRL+C to copy the cell(s)
get marqueed. When you move to a different cell they can be copied. But if
you save the sheet or do various other things like deleting a different
sheet in the workbook the clipboard is erased so that you can no longer copy
them into anything else. If I were to copy some cells to the clipboard and
then close the workbook, I would not be able to paste that info into
somethign else for example a Word doc. This is the only program I know of
that behaves this way. If I open a Word doc and copy some of its contents to
the clipboard and then close the doc, the clipboard contents are still there
to be used as needed.

One point I should make, I don't have my Office multiclipboard turned on. I
have never liked that feature. It gets in the way too much so I'm not sure
if the same thing happens if that function is on.

In any event, I'd love to know how to have Excel maintain the clipboard
contents or if it's not possible, what is the thinking behind this?

Thanks,

Keith

 

[Keith G Hicks]

Well I guess I'm not the only one that noticed this is broken for a LONG
time and has never been fixed!

http://www.goodexperience.com/tib/archives/2004/02/microsoft_excel.html

 

[Bob I]

Please elect to show the clipboard. You may then select what to Paste.

 

[Keith G Hicks]

Thanks Bob. That helps a bit. For that to work, you have to have the Office
Clipboard panel showing when you do the copy. Then you can paste whatever is
in it into other office files. But if you don't want the clipboard showing
(cuz it takes up too much space) then i guess your stuck. Thanks for the
info though. Like I said, it does help. At least now I know there's a
workaround.

 

[Keith G Hicks]

Thanks Bob. That helps a bit. For that to work, you have to have the Office
Clipboard panel showing when you do the copy. Then you can paste whatever is
in it into other office files. But if you don't want the clipboard showing
(cuz it takes up too much space) then i guess your stuck. Thanks for the
info though. Like I said, it does help. At least now I know there's a
workaround.

 

[Dana DeLouis]

For that to work, you have to have the Office

Clipboard panel showing when you do the copy.

Hi. If I understand, I believe you can hide the office clipboard while
copying. I may be wrong, as I haven't used it in a while.

http://office.microsoft.com/en-us/outlook/HP030823161033.aspx

Well I guess I'm not the only one that noticed this is broken for a >

LONG time and has never been fixed!

Just a guess on my part. I believe that Excel works a little
differently because there are a lot of cells(2007: 17,179,869,184)
The reason one can select this many cells and do Ctrl+C and "copy"
instantaneously is because it actually doesn't copy. It just sets a
reference. It would take forever to copy this many cells, along with
the formatting.
It takes a while to copy 4 whole columns in Excel via the office
clipboard where it is actually copying. If I remember, about 4 columns
is the memory limit of the office clipboard.
So, if there is anything that may compromise the integrity of the link,
then Excel closes the link.
In Excel 97, there was actually a way via programming to "trick" the
link and have a paste operation link incorrectly. However, this was
fixed in later versions.

= = = = = =
Dana DeLouis

 

[Bob I]

You may toggle viewing the Panel on and off at will. Please see
"Options" at the bottom of the Panel for more Options.