Broken copy paste upon enabling shared workbook [Office 2019]

mamradzelvy

New Member
Joined
Jul 1, 2020
Messages
11
Office Version
  1. 2016
Platform
  1. Windows
Hello,
I have a strange issue which i didn't manage to google sucessfully.

We have a workbook that we newly share between two people, using the legacy version.
We have merged cells in which we enter data, but when we try to copy the data into diferent merged cells, they un-merge again and the data gets pasted into just one of them, in a tiny format.
When we copy the inside of our workbook into a nonshared one, it works flawlessly again, but once we enable workbook sharing in the new document, it breaks the same way.
Any tips?

Here is what im trying to copy.
a1.PNG

Here is what happens when i paste it in shared workbook.
a2.PNG


Here is what gets pasted in non shared workbook.
a3.PNG
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Try this workaround until you get a complete solution

Click on cell that is being copied
{F2} to edit (or double click on cell)
{CTRL} a to select contents
{CTRL} c to copy (or rightclick\copy)

Click on target cell
{F2} to edit
{CTRL} v to paste (or rightclick\paste)
{Enter} to confirm
 
Upvote 0

Forum statistics

Threads
1,215,569
Messages
6,125,600
Members
449,238
Latest member
wcbyers

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top