the paste command copy wrong cell !

Question

Hi guys

i have problem with copy & past in my worksheet.

i have an excel workbook that's contain few sheets , in my main sheet when i copy a cell and past in somewhere else , it's copy the the lower cell of destination cell, for example  if i copy cell A1(AB) and choose B1(empty) for pasting then it's copy the B2(CD) value in B1 cell >> B1=CD !!!

these only happens in the main worksheet and copy command work well in other sheets.

.

note 1: if i use clipboard it's work OK.

Any suggestions can help.thank guys

Answer 1

here is the link of my file:

https://1drv.ms/x/s!An0ZIZxqvtGPghzNVh_qEgI9OLod

i using windows 7 32bit OS

Answer 2

Please share your file through onedrive so that I can check it. Which Operating System you are using?

Answer 3

thanks for your comment.

i have formula in my worksheet but it;s happen everywhere , the A1 cell was just an example, i try every paste option but all goes wrong. actually it's worked perfect until i paste data from another copy of my file(backup file).

.

.

.

I found another thing, the sheet had a table and if i convert the table to range the problem will solved, but i neeeed it to be a table !

Answer 4

I think there is a formula present in your A1 cell which is =A2. So that, while you copying A1 cell, it actually copying the formula which is =A2, whose value is AB. And when you paste in B1 cell then it actually pasting the formula in B1 cell and though it is a relative reference, it automatically changed the Column and Row number =A2 converted to =B2.

Try to paste as VALUE only.

It would be more clear if you share the snapshot.