alright, so I have tried it myself by copying some of the values to other sheet and pasting them as values and it actually works!

so the reason why it does not work for me is because the values in my cells are not actually values, but they are rather references (formulas), to be specific, VLOOKUPs from other sheets.
So how to adjust it so it would work in my case?