Drag and drop problem

[Novak20]

Hi,
Whenever I drag and drop cells within an excel table I'm getting 'There's already data here. Do you want to replace it?', even if the target cells are empty. The data is then moved anyway, whether I choose either 'ok' or 'cancel'.

I've tried clear formats or clear all from the target cells, same problem. I happens even if I drag and drop one empty cell to another empty cell.

The problem seems to be specific to tables. If I convert the table to a range, the problem goes away. But with any table, I'm back to square one.

thanks.

 

[jasonb75]

That will happen if you try to drag cells in from outside of the table but not if you drag them around in the table.

The data is then moved anyway, whether I choose either 'ok' or 'cancel'.

That shouldn't happen. Choosing cancel should do exactly what it says. If you have any vba events (worksheet change, selection change, calculate, etc) then it might be that the attempted drag is causing the code to execute and not allowing the cancel to function correctly.

 

[Novak20]

Thanks. It happens to cells within a table.
It doesn't seem to be vba: I've tried opening up a new workbook, constructing a table from scratch, and get the same problem.

The problem seems to be only with the query box showing up. If I try to drag and drop to a cell that has data in it and choose 'cancel', the data won't copy over. But if I move data to an empty cell, I get the 'There's already data ...' and copy and past happens whichever option I choose.

BTW, I've also tried deselecting 'Alert before overwriting cells' in the advanced options. The query box still shows up!

I'm using Office 365 on a PC.

 

[jasonb75]

I've just tried a simple test with the table below. I can drag any of the numeric cells already in the table to the empty cell in the table without any problems. Likewise dragging D5 into the table from outside of it is not causing an issue.

When I tried similar with an existing table earlier I did notice an anomaly where dragging a cell in from outside of the table returned a notification even when the destination cell was empty.
Having tried again with that table I am not able to reproduce the error again, leading me to the conclusion that perhaps the cell had a nullstring that I hadn't deleted.

Manexcel.xlsx
	A	B	C	D
1	a	b	c
2	1	2	3
3	4	5
4
5				6
Sheet8

The only thing that I can suggest is to try a new table in a new workbook on another PC. If the same thing happens there then that at least tells us that it is something that you are doing rather than a problem with excel. If that is the case then it is just a matter of figuring out what you're doing differently.