If the formula in the other sheet's cell that you're linking is returning a
"correct" zero, then you should also be getting a zero in the linked cell??
Perhaps it's more a case that your calc mode's inadvertently set to manual.
Do a quick check: Click Tools Options Calculation tab Check "Automatic"
OK. Does the linked cell now return correctly (presumably the sum over in
the other sheet is a non-zero value)?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Pascale" wrote:
Hello,
I am creating a summary page, when I type in the cell = (then I go get the
cell from the other page) if this other cell is a sum, I get 0.00 in my
summary.
Why is that? and how can i fix it?
Regards