View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Creating a summary page

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