You could modify your formula.

Formulas like:
='sheet 2!a1

would become
=if('sheet 2!a1="","",'sheet 2!a1)



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

--

Dave Peterson