Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find #ref! invalid cell references within cell formula | Excel Worksheet Functions | |||
Show actual values added instead of cell references? (=A1+A4 shows as=10+2 in cell) | Excel Discussion (Misc queries) | |||
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) | Excel Worksheet Functions | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) |