April

This is the behaviour when copying between workbooks in two instances of Excel.

I know of no way around it if you need two instances of Excel running.


Gord Dibben MS Excel MVP

On Wed, 12 Dec 2007 07:20:03 -0800, April H <April
wrote:

I have 2 separate excel files running on two separate computer monitors. I
am trying to copy and “paste special” a block of cells to move the value but
not the formatting from one document to the other. It will not allow me to
do this unless I want to paste an object into the target file. The only
other way I can paste the cells is a simple paste (by highlighting the cells
and pasting into the new location) in which the formatting is carried from
the origination document.