Hello,

The best way is to test it by yourself.

In Excel 2007, formulas that refer to another sheet (in the same workbook)
will be automatically changed by excel if you change the name of any sheet
of the workbook.






"Robert Crandal" a écrit dans le message de groupe de
discussion : ...
Cell formulas that refer to other sheets usually look like
this:

=Sheet2!A1 ' Get cell A1 from Sheet2

However, what if someone changed the name of the
Sheet2 tab to something like "ThisIsMyTab"??? Does that
mean I would have to manually change all possible formulas
to the following:

=ThisIsMyTab!A1

?????

I'm mostly curious if there's a way to use formulas that
do not strictly rely on the names of always changing
tab sheet names.

thank you