ExcelBanter - Paste Special Menu

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Paste Special Menu (https://www.excelbanter.com/excel-worksheet-functions/240585-paste-special-menu.html)

Paste Special Menu

When I click on the paste special menu like always it now brings up the
hyperlink menu (paste bitmap, etc.) rather than the paste special menu of
(all, formulas, values, etc.). How do i get the correct menu back? Clipboard
is clean.

Paste Special Menu

From where are you copying?

To where are you copying?

If from one workbook to another workbook, you may be running two instances
of Excel with a workbook open in each.

One instance can't see the other so gives you the alternate paste special
menu that you describe.

Close one instance of Excel and open both workbooks in one insrance.

Gord Dibben MS Excel MVP

On Mon, 24 Aug 2009 13:32:24 -0700, chanse44
wrote:

When I click on the paste special menu like always it now brings up the
hyperlink menu (paste bitmap, etc.) rather than the paste special menu of
(all, formulas, values, etc.). How do i get the correct menu back? Clipboard
is clean.