Sheets Names in Formulas

E

Ellen G

Hi there --

In a formula in one workbook, I am referencing a cell in a specific sheet in
another workbook. I have changed the name of the tab to TCh from Sheet3.
Because the tab name could change at any time, I would rather use Sheet3 in
my formula rather than TCh. It's not working for me though. My current
formula is:

='[Placement Goals -- 2008.xls]TCh'!S$26

Can I change TCh to Sheet3 so that no matter what I call the tab, the
formula works?

Just let me know if so and how.

Thanks so much,

Ellen G
 
S

Sean Timmons

The formula reads the tab name. As far as I know, you can't have a formula
look for the third tab in a workbook as a direct reference. However, If you
only change the name of the tab at bottom, it should update on the other
workbook anyway. When you open the workbook, it should ask if you want to
update your link. Just select Update.
 
J

Jim Rech

Can I change TCh to Sheet3 so that no matter what I call the tab, the
Only if the workbook with the formula is open so it knows about the change.

--
Jim
Ellen G said:
Hi there --

In a formula in one workbook, I am referencing a cell in a specific sheet
in
another workbook. I have changed the name of the tab to TCh from Sheet3.
Because the tab name could change at any time, I would rather use Sheet3
in
my formula rather than TCh. It's not working for me though. My current
formula is:

='[Placement Goals -- 2008.xls]TCh'!S$26

Can I change TCh to Sheet3 so that no matter what I call the tab, the
formula works?

Just let me know if so and how.

Thanks so much,

Ellen G
Click to expand...
 
E

Ellen G

Thanks, Sean.

The reason I suspect there might be a solution is because in a macro you can
address Sheet(3) even though it is named TCh. I'm wondering if there is a way
to do this in a formula.

Ellen

Sean Timmons said:
The formula reads the tab name. As far as I know, you can't have a formula
look for the third tab in a workbook as a direct reference. However, If you
only change the name of the tab at bottom, it should update on the other
workbook anyway. When you open the workbook, it should ask if you want to
update your link. Just select Update.

Ellen G said:
Hi there --

In a formula in one workbook, I am referencing a cell in a specific sheet in
another workbook. I have changed the name of the tab to TCh from Sheet3.
Because the tab name could change at any time, I would rather use Sheet3 in
my formula rather than TCh. It's not working for me though. My current
formula is:

='[Placement Goals -- 2008.xls]TCh'!S$26

Can I change TCh to Sheet3 so that no matter what I call the tab, the
formula works?

Just let me know if so and how.

Thanks so much,

Ellen G
Click to expand...
Click to expand...
 
Top