Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    339
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paste Options (Excel 2003 SP1)

    Hi all,

    A problem that has been bugging me. When I paste from the office clipboard I only get the option to "keep source formatting" or "match destination formatting" - see graphic. Once upon a time the options used to include stuff about the column widths, pasting values, pasting formulas etc. Anyone have any ideas what is happening here?

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Options (Excel 2003 SP1)

    It sounds like you may be confusing Paste with Paste Special. If you right-click after you've pasted, and choose Paste Special, you should still have all the old familiar options available. HTH
    Gre

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Paste Options (Excel 2003 SP1)

    Hi Karen

    I have done some searching and can not find any mention of some paste options being missing from the paste options button. I typically get 6-8 options appearing depending on what is being pasted. I have a couple of suggestions:

    1) Select "Tools>Options..." and on the Edit tab de-select "Show Paste Options buttons", click OK and then quit Excel. Re-start Excel and then select that option again. This is to check if the paste options that are displayed can be re-set.

    2) If the above does not work try running "Help>Detect and Repair..."

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    339
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Options (Excel 2003 SP1)

    Thanks for your response. .. I was talking about the paste options button which appears on the worksheet. If I do go to paste special the options are similarly limited.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    339
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Options (Excel 2003 SP1)

    Hi Tony,

    Thanks for your response ... I tried both of those suggestions but to no avail <img src=/S/sad.gif border=0 alt=sad width=15 height=15> Any chance this is a bug in SP1, I am sure it used to work fine?

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

    Re: Paste Options (Excel 2003 SP1)

    Where did you copy the data? In the same Excel session, or somewhere else?

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Options (Excel 2003 SP1)

    That is what you get when you copy text from another application and try to paste it into Excel. You only get the other options you mentioned if you copy cells from an Excel workbook and then do a Paste/Special.
    Legare Coleman

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    339
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Options (Excel 2003 SP1)

    Thanks for your responses. Data is copied from the same excel worksheet, have also tried it from another worksheet and from another workbook.

    If you use ctrl+c and ctrl+v it seems to work fine (ie copying from the WINDOWS clipboard). It is the OFFICE clipboard that is the problem.

  9. #9
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Options (Excel 2003 SP1)

    Are you coping a string of characters by selecting them in the formula bar or are you copying a complete cell. If you select a string of characters in the formula bar, that is what you are going to get. You have to copy a cell (nothing in the formula bar selected) to get all of the options.
    Legare Coleman

  10. #10
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    339
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Options (Excel 2003 SP1)

    copying a range of cells ... so nothing in the formula bar is selected

  11. #11
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Options (Excel 2003 SP1)

    In that case, I would try Jan Karel's suggestions in <!post=This Star Post,290455>This Star Post<!/post>. Particularly those related to REGSERVER and XLSTART.
    Legare Coleman

Posting Permissions

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