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" wrote:

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