'insert copied cells' missing

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
    8,964
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 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, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  10. #10
    New Member
    Join Date
    Oct 2010
    Posts
    13
    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!

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
  •  

 

 
DMCA.com