Paste Special in Excel 2003
 

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

Paste Special in Excel 2003
 

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

Paste Special in Excel 2003
 

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

On Thu, 24 Jul 2008 11:05:04 -0700, 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

Paste Special in Excel 2003
 

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

Paste Special in Excel 2003
 

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



f_r_e_d wrote:

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


--

Dave Peterson

Paste Special in Excel 2003
 

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" wrote:

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

On Thu, 24 Jul 2008 11:05:04 -0700, 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

Paste Special in Excel 2003
 

Try the usual fix for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

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

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "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 StartRun "C:\yourpath\excel.exe" /regserver(quotes
required)OK.


Gord Dibben MS Excel MVP

On Thu, 24 Jul 2008 12:16:02 -0700, f_r_e_d
wrote:

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