Formula and Sheet Name

Robert S Fike

I have several sheets that pull data from another sheet. On each of the sheets that pull from the one, each have multiple formulas.

If i change the name of the sheet with the data, does that effect the formulas on each of the other sheets.

SoS | Dan Palenchar

Hello @Robert S Fike,

You can change the name of any of the Sheets as well as the columns themselves and even the column type (though depending on the nature of the formula changing the column type might invalidate your formula).

Cross Sheet formulas map to the literal column itself and are maintained so long as the column is not deleted from the Sheet or the reference itself is not deleted from the reference manager.

Hope that helps!

SoS | Dan Palenchar

Hello @Robert S Fike,

You can change the name of any of the Sheets as well as the columns themselves and even the column type (though depending on the nature of the formula changing the column type might invalidate your formula).

Cross Sheet formulas map to the literal column itself and are maintained so long as the column is not deleted from the Sheet or the reference itself is not deleted from the reference manager.

Hope that helps!

Robert S Fike

TYVM

SoS | Dan Palenchar

@Robert S Fike my pleasure!

Robert S Fike

These are helpful. Is there a class you teach or just do videos