Forum Discussion
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....
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.