When i create a formula from another sheet i can not fixed the link. Examply
the formula is "=sheet2!$A$1" in sheet 1, when i add a column before the
column of the A column then the formula gets the new data as "=Sheet2!$B$1"
but i don't want to excel point the new cell, i want it to be fixed at
"=Sheet2!$A$". Any way to solve this problem?