sir, actually i am facing problem in excel while taking/linking the value from one file to another file.
i got 2 file - 1st one is master where it shows total stock
2nd file - where i add & remove item. so final difference qty in 2nd file should appear in 1st file.

the problem is if i open 1st file without opening 2nd file it shows error as " #value! ", it's not showing any value in 2nd file.

how to solve this problem.

please reply to this query asap...plz...........