Paste Special in Excel 2003

[f_r_e_d]

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

 

[Elkar]

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

 

[Gord Dibben]

Sounds like you have each workbook open in separate instances of Excel.

Close one instance and open both workbooks in a single instance.


Gord Dibben MS Excel MVP

 

[f_r_e_d]

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

 

[Dave Peterson]

Close every instance of excel
Open the first workbook in excel
then use File|Open to open the second.

 

[f_r_e_d]

Thanks All, yes it seems it is working this way.

Now I have to modify my vba code to open each document from within each other.

Good.

Thanks,

f_r_e_d

 

[Gord Dibben]

Try the usual fix for this.

Tools>Options>General Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case Start>Run "C:\yourpath\excel.exe" /regserver(quotes
required)>OK.


Gord Dibben MS Excel MVP