Thanks Elkar,

Can you tell me how my workbooks can be in the same instance?
What should I do to make them to be in the same instance?

Thanks,

f_r_e_d

"Elkar" wrote:

The difference is if the second workbook is opened within the same instance
of Excel or a separate instance. If the workbooks are in the same instance,
you will see the normal Paste Special options you're looking for. If the
workbooks are each in their own separate instance of Excel, then you see the
other menu.

In the later instance, if you just want to Paste Values, you should be able
to select "Text" and get your desired results.

HTH
Elkar


"f_r_e_d" wrote:

Hi Guys,

- I've created 2 blank Excel documents(book1, and book2)
- I entered aa,bb,cc in A1,A2,A3
- Copy A1 to A3 and tried to paste it into B1 using paste spacial
- paste special menu comes up and I can select values

now

- If I Copy A1 to A3 from book1 and try to paste into book2 using paste
special
- paste special menu (but this time it is different) opens up and it does
not have a normal paste, values, formats, all, etc.
- In this case, paste special menu has picture, bitmap, html, etc.

Can you tell me how can I paste special into book2 and see the normal paste
special menu which I see in book1? (paste by values)

Is this an OS related setting?

Someone has suggested to "uncheck" the in memory checkbox in Excel.

Any Ideas?

Thanks,

f_r_e_d