Are you ctrl-dragging a single cell to a worksheet in another workbook?

If yes, then make sure that both workbooks are open in the same instance of
excel.

Close one of the workbooks (and that instance of excel)
and use File|open in the first instance and open your file there.

Then try it out.

ajs wrote:

Recently when i try to copy a formulae from a cell and drag it into
another cell it is only copying the value. The formulae drags the
number from another worksheet. It has only recently started doing
this, i have tried to fix it using various paste special options but
nothing seems to work. Any ideas?

--
ajs
------------------------------------------------------------------------
ajs's Profile: http://www.excelforum.com/member.php...o&userid=36046
View this thread: http://www.excelforum.com/showthread...hreadid=558379

--

Dave Peterson