1) I have referenced values from One work sheet to another.When I try to sum
up the referenced values I get 'zero'. Even when I try to do a calculation
with referenced value it does not work.
2) Again if in a work book I insert a formula a particular cell the result
again shows 'zero'. While the formula works in other cells.

Why am i facing these problem. My office version is licensed one. It office
2000 installed on Windows XP.

Can anybody plese help me to resolve this.

With regards
Ravi