copy-paste special window

[spoki007]

when i open 2 excel worksheets,and i wont to do copy(1.excel) and paste
special in second excel,its hapend this4358

i canot see normal paste special windows where are
values,formulas....?
please at mail (e-mail address removed)


+-------------------------------------------------------------------+
|Filename: excel.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4358 |
+-------------------------------------------------------------------+

 

[hansyt]

It seems that you are not in Excel but in Word when you do your
copy/paste i.e. yoiu aare trying to copy an Excel worksheet object from
one document into another.

Hans

 

[spoki007]

2 excels are opened.....
and if are formulas into cells,and copy-paste in another sheet its copy
only values not formulas


+-------------------------------------------------------------------+
|Filename: excel3.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4407 |
+-------------------------------------------------------------------+

 

[spoki007]

settings into file type/xls....
:

+-------------------------------------------------------------------
|Filename: file options.JPG
|Download: http://www.excelforum.com/attachment.php?postid=4408
+-------------------------------------------------------------------