Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: 'insert copied cells' missing

  1. #1
    Board Regular
    Join Date
    Jan 2005
    Posts
    142
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 'insert copied cells' missing

    Hi,

    I have a user that is using the copy command and then going to another workbook and trying to use the 'insert copied cells' command by right clicking over a cell.

    The menu shows 'Insert' only. I have had the workbook sent to me and it works for me.

    Is there a setting or something that stops this option?

    Thanks in advance.

  2. #2
    Board Regular
    Join Date
    May 2007
    Location
    rexburg idaho
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'insert copied cells' missing

    check too see if the excel version are the same on yours and if they are different on hers..


    that is the only thing i can think of that would make a difference.


    John

  3. #3
    Board Regular
    Join Date
    Jan 2005
    Posts
    142
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'insert copied cells' missing

    Yes, I've checked that....she is on the same version...

  4. #4
    Board Regular
    Join Date
    May 2007
    Location
    rexburg idaho
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'insert copied cells' missing

    the only other thing i canthink of is if she has it opened in compatibility mode if she does many functions are disabled.

    srry i'm not more helpful.

    john

  5. #5
    Board Regular
    Join Date
    May 2007
    Location
    rexburg idaho
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'insert copied cells' missing

    if she opens her file and it does say compatibility mode at the very top center, then have her save as the file as a regular file.

    crazy excel.

    John

  6. #6
    Board Regular
    Join Date
    Jan 2005
    Posts
    142
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'insert copied cells' missing

    I'll give it a go...Thanks

  7. #7
    Board Regular
    Join Date
    Jan 2005
    Posts
    142
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'insert copied cells' missing

    She can't see it....Is there any other way of finding out whether it is in this mode.

  8. #8
    New Member
    Join Date
    May 2012
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'insert copied cells' missing

    A colleague has just come across this problem and I found that if filters were cleared (Do not have to be turned off but nothing should be filtered), that resolved the issue.
    My regards,
    Paul

  9. #9
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    9,779
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: 'insert copied cells' missing

    Try going into excel options and make sure that the for objects show > all checkbox is ticked
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  10. #10
    New Member
    Join Date
    Oct 2010
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: 'insert copied cells' missing

    Quote Originally Posted by paul.jenkin View Post
    A colleague has just come across this problem and I found that if filters were cleared (Do not have to be turned off but nothing should be filtered), that resolved the issue.
    My regards,
    Paul
    Worked for me. Thanks!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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