Tabla Dinamica - Ayuda

%3CLINGO-SUB%20id%3D%22lingo-sub-2360284%22%20slang%3D%22es-ES%22%3EDynamic%20Table%20-%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2360284%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EThey%20could%20help%20me%2C%20please%20know%20because%20I%20can't%20select%20New%20Spreadsheet%2C%20when%20I%20try%20to%20choose%20where%20I%20want%20to%20place%20the%20PivotTable%20report%2C%20apparently%20the%20option%20I%20mention%20is%20disabled%20and%20I%20can't%20continue%20with%20my%20exercise%2C%20beforehand%20thank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EMiguel%20Mendoza%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2360284%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2362999%22%20slang%3D%22en-US%22%3ERe%3A%20Tabla%20Dinamica%20-%20Ayuda%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2362999%22%20slang%3D%22en-US%22%3E%3CP%3EHola%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1055629%22%20target%3D%22_blank%22%3E%40MiguelMendoza1212%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHaga%20clic%20en%20Insertar%26gt%3B%20Tabla%26gt%3B%20Tabla%20din%C3%A1mica%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_0-1621311969499.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281434i71A20F76F9396075%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_0-1621311969499.png%22%20alt%3D%22Yea_So_0-1621311969499.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAparece%20este%20cuadro%20de%20di%C3%A1logo%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_1-1621312086331.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281435i2B3A2DA8ADC8FB9C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_1-1621312086331.png%22%20alt%3D%22Yea_So_1-1621312086331.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESeleccione%20Hoja%20de%20trabajo%20existente%20y%20seleccione%20la%20celda%20donde%20le%20gustar%C3%ADa%20que%20est%C3%A9%20su%20tabla%20din%C3%A1mica%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_2-1621312267989.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281436i842A23D4CD4EAED1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_2-1621312267989.png%22%20alt%3D%22Yea_So_2-1621312267989.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ehaga%20clic%20en%20la%20flecha%20que%20apunta%20hacia%20arriba%20en%20la%20Ubicaci%C3%B3n%20y%20luego%20se%20ver%C3%A1%20as%C3%AD%2C%20luego%20haga%20clic%20en%20la%20celda%20donde%20desea%20colocar%20la%20tabla%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_3-1621312424790.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281437i177679933EDDEF2C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_3-1621312424790.png%22%20alt%3D%22Yea_So_3-1621312424790.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hola

Me podrían ayudar, por favor quisiera saber porque no puedo seleccionar Nueva hoja de calculo, cuando intento elegir donde deseo colocar el informe de tabla dinámica, al parecer la opción que menciono se encuentra desactivada y no puedo continuar con mi ejercicio, de antemano agradecer su ayuda.

Gracias

Miguel Mendoza 

1 Reply

Hola @MiguelMendoza1212 

Haga clic en Insertar> Tabla> Tabla dinámica

Yea_So_0-1621311969499.png

Aparece este cuadro de diálogo

Yea_So_1-1621312086331.png

Seleccione Hoja de trabajo existente y seleccione la celda donde le gustaría que esté su tabla dinámica

Yea_So_2-1621312267989.png

haga clic en la flecha que apunta hacia arriba en la Ubicación y luego se verá así, luego haga clic en la celda donde desea colocar la tabla

Yea_So_3-1621312424790.png