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.  Can someone help with this  

Formulas and Functions

2 Replies

  • Olufemi7's avatar
    Olufemi7
    Iron Contributor
    Feb 16, 2026

    HelloDrMichaelS​, You are getting the #NAME? error because the sheet name contains a space. Excel requires sheet names with spaces to be enclosed in single quotes.

    Change your formula to

    ='AOV Calculation'!D6

    That should resolve the error.

  • 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