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.
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.