8/4/14 When you add text to a worksheet and refresh, SmartView examines the newly added text to see whether it was your intention to extend the grid If a member is identified, but it belongs to a dimension that is inappropriate for the column or row it is in, the error will be generatedIn case you get #NAME error message in excel Here's a full guide for correcting it23/4/08 Mike, you can select all cells with errors very quickly Press F5 (or menus Edit > Goto) Click 'Special' Select 'Formulas' Uncheck Numbers, Text and Logicals, leaving 'Errors' checked Click OK That will simultaneously select all cells with errors on the sheet (If you want to limit it to one column, select just that column first)
Excel Formula How To Fix The Name Error Exceljet
