Thread: pasting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Gerstman David Gerstman is offline
external usenet poster
 
Posts: 57
Default pasting

Thank you very much.

David

"bj" wrote:

it sounds as though you are different occurances of Excel.
if you want to copy directly you must be in the same occurance
try opening two workbooks from the file-open command and see what happens

"David Gerstman" wrote:

I hope this is the correct forum for this question; I didn't see a more
appropriate choice.

When I copy or cut and paste within a workbook from one worksheet to another
and I choose "Paste Special" I'm given a range of choices such paste
formulas, column widths, values or formats etc.

But if I try to paste to a new workbook and I use "Paste Special" I get a
different dialog box giving me choices of pasting an Excel Object, a bitmap,
XML spreadsheet or HTML (etc). Is it possible to get the other dialogue if
I'm pasting to a different workbook?