MS Excel 2010 help.. External data links not updating

[amirkhan0]

dear excel expert mujhy help chaye mery pas excel 2010 hai kch din se aik problem chal rha ha. mere file k sth jo external links hain wo update nai hoty automatically. m ne sab kch kr k dekh liya ha links update alert bhi nai aa rha jab k m ne option startup promt me let user choose alert diya hua ha. dosri bat me ne File > Options > Advanced> General> As to update automatic links check mark b lagaya hua ha. phr b problem fix nai ho rha.. koi help plzz
note: mere pas dosri files hain unme alert ata ha values automatic ho jati hain but is file me nahe ho rhe..

[sajidbagi]

formulas k tab mein ja kar.......calculation option mein jao aur automatic par tick laga do

dosra tareeqa yeh hai k data k tab mein ja kar edit links par click karo aur old file k link ki jaga dobara file ka link select karo INSHAALLAH masla hal ho gayega

[KAMALUDIN]

Bahi ya thu dobara install karo ya 2016 office ko install problum solve

[amirkhan0]

bhai me ni aisa he kya ha boht dafa try kr chuka hu or ab to me ne rapair b kr diya ha office but still my problem is same.. khud he value update krta hu auto alert nai ata jb option b set ha auto ka

[amirkhan0]

ye to koi hal nai ha yar