Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paste Special (XP)

    What is the difference between the two paste special screen shots? We are all familiar with the standard paste special command (right click and paste special). What would cause the other one to appear as opposed to the standard one?

    Thanks,
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Paste Special (XP)

    The smaller one (with All, Formulas, etc.) is the dialog you get when you copy a bunch of cells to the clipboard, then select Edit | Paste Special...

    You'll get the larger one (with Microsoft Excel Worksheet Object etc.) for example if you insert an Excel worksheet object into a Word document, copy the object or some cells in it to the clipboard, then select Edit | Paste Special... in Excel.

    The other difference, of course, is a different setup in the Display Properties control panel.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Special (XP)

    Hans,

    What you describe makes sense. The only challenge here is that it is a direct copy/paste special from one Excel workbook to another.

    John

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Paste Special (XP)

    This probably means that you inadvertently started two instances of Excel. If you copy a range in one instance, and try to paste special into the other one, you'll get the version with Excel Worksheet Object etc.

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Special (XP)

    Hans,

    That is exactly what happened; two instances of Excel open.

    Many thanks,
    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •