Copy table cell and paste as value returns wrong value

[olofmur]

Hi,

I have this weird problem that when I copy a cell value in my table and paste it in the same cell as value to get rid of the formula I end up with another value than the one I copied. Specifically, it pastes the value identical to the value on the next row. Example

COLUMN HEADER
AAA
BBB
CCC

If i copy AAA and paste it in cell AAA result is

COLUMN HEADER
BBB
BBB
CCC

I have cleared all filters, unhid all rows and columns and removed the subtotal calculations (these were solutions that I found so far). Anyone have an idea of what this could be and why it is happening?

BR Olof

 

[olofmur]

bump?