Copy - Paste

  • Thread starter Thread starter excel_googler
  • Start date Start date
E

excel_googler

Normally, after copying data & selecting paste special, you normally get
paste special window ( paste, operation, skip blanks, transpose etc..).
But sometimes another window pop ups instead of regular window.
Can any one please guide why this happens and possible solution to get
the normal options
 
When you copy from one application to another you can get this prompt.

I'm gonna bet that you have two instances of excel running--with a workbook open
in each instance. If you look under Window, do you see one workbook or two?

If you close one of the workbooks and that instance of excel, you could use
File|open to open the file in the existing instance of excel. Then you're
copy|paste special will look more familiar.

If you opened separate instances of excel on purpose, then ignore this, but if
you really only want one instance...

Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.
 
Back
Top