paste "oddity"

[john.e.palmer]

In both Excel 2004 and 2008, if I do a Cmd+C and then a Cmd+V to cut
and paste a formula, it works as it should. However, if I do another
action prior to the Cmd+V, it pastes the result of the original copy,
not the formula. This happens if I right click and paste as well.

In Win Excel, I get a beep when I try to paste after another action.
Is there any way to have Mac Excel to either paste the formula instead
of the original value or to just to sit there and thumb it's nose at
me?

Thanks.

 

[Bob Greenblatt]

In both Excel 2004 and 2008, if I do a Cmd+C and then a Cmd+V to cut
and paste a formula, it works as it should. However, if I do another
action prior to the Cmd+V, it pastes the result of the original copy,
not the formula. This happens if I right click and paste as well.

In Win Excel, I get a beep when I try to paste after another action.
Is there any way to have Mac Excel to either paste the formula instead
of the original value or to just to sit there and thumb it's nose at
me?

Thanks.

This is just the way Excel works. When you remain within Excel, the marquis
around the copied cell is active, and the clipboard contains all the cell
references. So when you past to another cell, the formula gets pasted and
updated as it goes to the new location. When you do something else, the
original cell's reference gets deleted, and the clipboard contents change to
the original cell's contents, so it can be pasted to another application.
This is a result of Excel's interaction with the operating system to
maintain the clipboard integrity. I don't think there is anything you can do
to change this.

 

[john.e.palmer]

This is just the way Excel works. When you remain within Excel, the marquis
around the copied cell is active, and the clipboard contains all the cell
references. So when you past to another cell, the formula gets pasted and
updated as it goes to the new location. When you do something else, the
original cell's reference gets deleted, and the clipboard contents change to
the original cell's contents, so it can be pasted to another application.
This is a result of Excel's interaction with the operating system to
maintain the clipboard integrity. I don't think there is anything you can do
to change this.

That makes sense. Thanks for the info. I'll just have to alter my
winXP habits <g>.

 

[CyberTaz]

<snip>
In Win XL you get a beep because the intervening action has caused the
clipboard to be cleared so there is nothing available to be pasted. The beep
isn't so much an Excel thing as it is one of those pesky Windows "error"
nuisances