copy an excel mac os sheet and paste to another sheet 2019

If issue persists, I would like to confirm information below to help you further troubleshoot the issue.ġ.Please share a screenshot of the error message ' This action won't work on multiple selections'.Ģ.Seems your Office version is 16.33(20011301). Safe mode helps you check if issue is caused by any background program.ĭisclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise,Īnd is not responsible for the information you receive from the third-party linked sites or any support related to technology. Reboot Mac in safe mode to see if issue still appears. This can help you narrow down if issue only happens in those existing workbooks. As new workbooks work well, have you tried to copy and paste all content to a new workbook and see if it works? Seems you can remove the protection for the workbooks. (If there is something I misunderstand, feel free to correct me.)

This issue only appears in the existing workbooks, new workbooks work fine. I notice there is no reply in this thread, so I would like to help here.įrom your description, I undertsand the issue is that you cannot copy/paste across internal or external sheets and you cannot add/delete sheets. Update : MS Community emailed me to call on **** but that number is either discontinued or not reachable internationally Tried on an earlier version of Excel (2011) : at least I could add/delete sheets, but soon enough even simple copy/paste of continuous ranges of just data across workbooks produced the same error message.įrustrated and needing help urgently… Thanks. I installed the product last June and maybe the bug was already there, it's just that I did not have to do these operations until now (copy/paste across different workbooks). But for some reason it does not like such operations from my existing 'master' book The copy/paste etc seems fine across new workbooks.

I spent several hours reading through them, trying the different tricks. And suddenly I can't copy/paste simple selections across internal or external sheets, nor can I add/delete sheets - and I get always the same error message : ' This action won't work on multiple selections.'.Ĭonsulted the forum pages only to discover to my dismay that hundreds of similar user issues exist, some with weird workarounds, but many without.

Protected workbook, no macros (but removing protection I have a workbook with some 12 sheets, one of the workhorses of our accounting system. I run Office, in this case Excel 2019 for Mac v16.33 (Student/Home version) on the latest iMac with MacOS X Mojave.

Copy an excel mac os sheet and paste to another sheet 2019