You can not create or use the data range reference because it is too complex

I tell you that you gave me this error in excel when I filtered information and I wanted to copy them, I found that Excel only allows you to select non-contiguous ranges of 8,192 areas.

Non-contiguous Ranges

las soluciones para este problema son:

 - Ordernar primero los valores de la columna que quieren filtrar.
 - Seleccionar segmentos menores a 8,192.