If the worksheet is on an open workbook, all the formulas that refer to that
worksheet should change automatically as you change the name.
Also, you can use Find/Replace from the Edit menu, if you have indirect
formulas. Try first on a backup copy, in any case.

Hope this helps,
Miguel.

"Leann" wrote:

I would like to be able to change the name of a worksheet and have it change
in all of the formulas that reference it as well. Is there an easy way to do
this?