Paste Special

  • Thread starter Thread starter Nate
  • Start date Start date
N

Nate

Sometimes when copying data from one spreadsheet to paste into another,
I get a different "Paste Special" dialog box that seems to be treating
the data as an Object or Picture etc. (rather than the "normal" dialog
box which offers the options of 'Values', 'Formulas' etc.). I've never
been able to figure out why this is. Anyone have any ideas?
 
If both workbooks are open in the same instance of excel, you'll see the
"normal" paste|special dialog.

But it sounds like you have two instances of excel running. I'd close one of
the workbooks (and that instance of excel) and use File|open in the other
instance.

Then try the copy|paste special stuff.
 
Its because, both the spreadsheets are not in the same excel window...

If you have the files opened with one excel instance, then you will see the
normal paste special box with various options, But when you try to copy from
one excel instance and paste it another instance, you will see the different
dialog box....
 
Back
Top