Links not linking

Hello

I have written a fairly big spreadsheet linking through the pages with SUM,
SUMIF and SUMPRODUCT formula's

What I am now finding is that when I update one page it doesn't update the
rest, even if I am only typing in a figure to the SUM function.

I have check and the calculations function is on automatic.

is there a fix or something that I could run to make sure that all the
formulas are working correctly.

thanks

Dave
Fri Nov 05 14:48:35 CST 2004

Just a guess (since you already checked tools|options|calculation tab).

How about selecting all the cells (ctrl-a (twice in xl2003)) and then
edit|replace
what: = (equal sign)
with: = (equal sign)

Excel should see it as a change and reevaluate the formulas. Maybe that will
wake up excel.



Joe wrote:
>
> Hello
>
> I have written a fairly big spreadsheet linking through the pages with SUM,
> SUMIF and SUMPRODUCT formula's
>
> What I am now finding is that when I update one page it doesn't update the
> rest, even if I am only typing in a figure to the SUM function.
>
> I have check and the calculations function is on automatic.
>
> is there a fix or something that I could run to make sure that all the
> formulas are working correctly.
>
> thanks

--

Dave Peterson
ec35720@netscape.com

westdr1
Sun Nov 07 05:41:48 CST 2004

Had a similiar problem with an Excel project using xl97. I finally
dumped the project and found another app to accomplish the task. I see
the problem still exist based on the info on the web.
There is a tool that works well that you can download at the
following;

http://www.cpearson.com/excel/xltools.htm

There is also an add in program $49(?) on the web. There is also a
review (FWIW) at a PC Mag website.

HTH

"Joe" <someone@microsoft.com> wrote in message news:<OYcUa51wEHA.3228@TK2MSFTNGP10.phx.gbl>...
> Hello
>
> I have written a fairly big spreadsheet linking through the pages with SUM,
> SUMIF and SUMPRODUCT formula's
>
> What I am now finding is that when I update one page it doesn't update the
> rest, even if I am only typing in a figure to the SUM function.
>
> I have check and the calculations function is on automatic.
>
> is there a fix or something that I could run to make sure that all the
> formulas are working correctly.
>
> thanks