error #NAME? excel y visual chart (1/1)

error #NAME? excel y visual chart

10/12/11 11:47

Hola, intento copiar una tabla de datos en tiempo real de VisualChart a Excel (2010 y 2003) y me sale el siguiente error:

#NAME?
la fórmula es: =EXTRAE(INDIRECTO(DIRECCION(FILA();COLUMNA()-4));11;8)

Ese tipo de error surge cuando no reconoce la EXTRAE, la cambio por MED y tampoco, ni tampoco por MID.
Gracias.

Re: error #NAME? excel y visual chart

Nuevo

22/01/26 07:06

That #NAME? error usually appears when Excel can't recognize a function name or when copied text includes unsupported characters, which also affects visual charts and labels. I've seen this happen when users paste styled or Unicode text into chart titles. A quick fix is to clean the text or retype it using plain characters. I often test how special fonts behave in tools like this one: https://instanamesstyle.com/