Ok I am trying to create a cell that displays an IP address based on a
starting address on the front page. The address that I start this off of is
actually 4 cells (one for each octet) which I am combining together. It
works fine, but my problem is that if I change one of the numbers on the
front page, it doesnt pass the update along to all of the other cells based
on that. My formula is.

=Sheet1!$C$1&"."&Sheet1!$E$1&"."&Sheet1!$G$1&"."&Sheet1!A3

Would love any help you can offer.

Troy

tools=>Options, calculation tab, make sure calculate is set to Automatic.
(sounds like it is set to manual)

--
Regards,
Tom Ogilvy

"Troy W." <Troy W.@discussions.microsoft.com> wrote in message
news:EB15DA81-61A5-46D3-9966-(E-Mail Removed)...
> Ok I am trying to create a cell that displays an IP address based on a
> starting address on the front page. The address that I start this off of
> is
> actually 4 cells (one for each octet) which I am combining together. It
> works fine, but my problem is that if I change one of the numbers on the
> front page, it doesnt pass the update along to all of the other cells
> based
> on that. My formula is.
>
> =Sheet1!$C$1&"."&Sheet1!$E$1&"."&Sheet1!$G$1&"."&Sheet1!A3
>
> Would love any help you can offer.
>
> Troy