Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2013
    Posts
    7
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Error message, "This action won't work on multiple selections"

    I am having a strange issue with Excel 2016. Whenever I try to copy and paste cells from one workbook to another, I get the message “This action wont’ work on multiple selections”. This happens even one a single cell is selected for copy/paste (or cut/paste). On these problem files, I cannot even move my worksheets around, or add or delete worksheets (and no, the menu items are not greyed out; they just will not work). I think somehow the files got corrupted. The only workaround I found is to use the ‘clipboard’, which allows a pasting of values only (not formulas).

    Wondering if anyone has had the same experience, and if you found the cause and solution? An internet search reveals that many have seen this problem, with no good fixes posted. Few other pertinent facts:
    1. Neither the worksheet nor the workbook are protected
    2. There are several macro files running in the files. However, several other files with the exact same macros are working perfectly.

    Thanks much in advance.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi Satnair

    ..this sound like an Excel vba event routine that isn't expecting, or designed to deal with, multiple cells.
    For example, a 'change event' that is designed to work when a single cell is 'changed' might not be coded to cope when a block of cells are 'pasted' i.e. multiple cells changed at the same time.

    zeddy

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 650 Times in 592 Posts
    This can happen if there are merge cells in the copy or merged cells in the area you are pasting to.

    HTH,
    Maud

Posting Permissions

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