vba - All reference values in Excel sheet becomes '!#REF! when refering values from another sheet -

one of our excel program stops working , trying figure out why.

in program, there multiple sheets. 1 cannot calculate value called "piston", , reason reference values sheet called "general input" fail refer.

the following failed cells in "piston" sheets:

='general input'!#ref!*(0.0063/0.0111)*exp(-1*0.0214*$c$9) ='general input'!#ref!*exp(-1*0.0214*$c$9) =ab5*(ad5+ac5*dg5)/(ad5+ab5*dg5)/'general input'!#ref! =$c$8*0.0000032/('general input'!#ref!*piston!$c$4*piston!n10*(2*$c$6/1000)^2*('general input'!$c$16/1000)^2) =((bv9^3)*(bq9^2)/dj9/8+(bw9^3)*(br9^2)/dk9/4+(bx9^3)*(bs9^2)/ae9/4+(by9^3)*(bt9^2)/dl9/4+(bz9^3)*(bu9^2)/dm9/8)/12/'general input'!#ref!*$g$26/(1000000)^3 

apparantly different values in "general input" fail @ same time. not 1 wrote code, , don't use well. asked fix bug.

but want ask, there reason make referred value fail sheet?

sorry if information provided vague.

!#ref! used cell reference - e.g. $g$9

 ='general input'!#ref!*(0.0063/0.0111)*exp(-1*0.0214*$c$9) 

however, such link/reference g9 doesn't exist anymore - e.g. g9 deleted.

the best hope saved different version of such excel. if yes, go older version , copy formula.

good luck.