Cell References
 

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&"."&S heet1!A3

Would love any help you can offer.

Troy

Cell References
 

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

--
Regards,
Tom Ogilvy

"Troy W." <Troy wrote in message
...
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&"."&S heet1!A3

Would love any help you can offer.

Troy