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.

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.