Forum Discussion

DrMichaelS's avatar
DrMichaelS
Copper Contributor
Feb 15, 2026

Name error

I am attempting to link a special cell on another tab but am getting the Name error.  This is the formula   =@AOV Calculation!D6 This is a screen shot I have no idea how to fix this error....
Formulas and Functions
m_tarler's avatar
m_tarler
Bronze Contributor
Feb 16, 2026

So your formula doesn't make sense to me.  

=@AOV Calculation!D6

First off why do you have the @ symbol?

Is 'AOV Calculation' the name of the Tab/sheet?  If so, because there is a space in the name you much wrap it with single quotes so try:

='AOV Calculation'!D6