URGENT manque une fonction sur EXCEL

%3CLINGO-SUB%20id%3D%22lingo-sub-3005977%22%20slang%3D%22fr-FR%22%3EURGENT%20misses%20a%20function%20on%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3005977%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20contacted%20help.microsoft.com%20who%20directed%20me%20to%20you%20with%20a%20file%20number%20as%20a%20reference%20for%20this%20chat%3A%201031785186%3C%2FP%3E%3CP%3EOn%20my%20Excel%20version%2016.55%20(21111400)%2C%20I%20am%20missing%2C%20as%20in%20the%20attached%20image%2C%20at%20the%20bottom%20of%20the%20box%20%22Create%20a%20PivotTable%22%2C%20the%20mention%3A%3C%2FP%3E%3CP%3ESpecify%20whether%20you%20want%20to%20crawl%20multiple%20tables%3C%2FP%3E%3CP%3E(check%20box)%20Add%20this%20data%20to%20the%20data%20model%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20image%20with%20an%20attached%20board%20is%20an%20image%20capture%20of%20an%20online%20course.%3C%2FP%3E%3CP%3EThe%20image%20without%20attached%20table%20is%20a%20capture%20of%20my%20Excel%20without%20the%20function%20I%20just%20detailed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20urgent%20because%20without%20this%20function%20I%20can%20not%20work%20my%20courses.%20Thank%20you.%20Sandrine%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture%20d%E2%80%99e%CC%81cran%202021-11-25%20a%CC%80%2012.58.53.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329462i549F6D7C5AAC2AE5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Capture%20d%E2%80%99e%CC%81cran%202021-11-25%20a%CC%80%2012.58.53.png%22%20alt%3D%22Screenshot%202021-11-25%20at%2012.58.53.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture%20d%E2%80%99e%CC%81cran%202021-11-25%20a%CC%80%2015.07.41.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329464iBACF24602D2B3656%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Capture%20d%E2%80%99e%CC%81cran%202021-11-25%20a%CC%80%2015.07.41.png%22%20alt%3D%22Screenshot%202021-11-25%20at%2015.07.41.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour,

 

Je viens de contacter help.microsoft.com qui m'a orienté vers vous avec un numéro de dossier comme référence de ce tchat : 1031785186

Sur mon Excel version 16.55 (21111400), il me manque, comme dans l'image ci-jointe, en bas de l'encadré "Créer un Tableau Croisé Dynamique" , la mention :

Indiquer si vous souhaitez analyser plusieurs tables

(case à cocher) Ajouter ces données au modèle de données

 

L'image avec un tableau jointe est une capture d'image d'un cours en ligne.

L'image sans tableau jointe est une capture de mon Excel sans la fonction dont je viens de détailler.

 

C'est urgent car Sans cette fonction je ne peux pas travailler mes cours. Merci. Sandrine

Capture d’écran 2021-11-25 à 12.58.53.png

Capture d’écran 2021-11-25 à 15.07.41.png

 

0 Replies