How to get pivot table to draw from two sheets of data

%3CLINGO-SUB%20id%3D%22lingo-sub-1742634%22%20slang%3D%22en-US%22%3EHow%20to%20get%20pivot%20table%20to%20draw%20from%20two%20sheets%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742634%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20large%20amount%20of%20data%20that%20I%20am%20trying%20to%20pull%20into%20one%20pivot%20-%20the%20data%20is%20in%20two%20sheets%20and%20is%20an%20extension%20of%20the%20same%20data%20with%20the%20same%20headings%20but%20even%20after%20I%20have%20copied%20the%20data%20into%20one%20sheet%20(with%20over%20115000%20lines!)%20it%20wont%20pull%20through%20the%20data%20correctly%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20please%3F%3C%2FP%3E%3CP%3EThanks%20so%20much%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1742634%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1743055%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20to%20get%20pivot%20table%20to%20draw%20from%20two%20sheets%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1743055%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F818997%22%20target%3D%22_blank%22%3E%40Becskters%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-556019442%22%20id%3D%22toc-hId-556019442%22%3E%3CFONT%20size%3D%224%22%3EAdd%20worksheet%20data%20to%20a%20Data%20Model%20using%20a%20linked%20table%3C%2FFONT%3E%3C%2FH1%3E%3CDIV%3E%3CDIV%20class%3D%22appliesTo%20collapsed%22%3E%3CFONT%20size%3D%222%22%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20for%20Microsoft%20365%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202019%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202016%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202013%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%20class%3D%22appliesTo%20collapsed%22%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22appliesToItem%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-worksheet-data-to-a-data-model-using-a-linked-table-d3665fc3-99b0-479d-ba09-a37640f5be42%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-worksheet-data-to-a-data-model-using-a-linked-table-d3665fc3-99b0-479d-ba09-a37640f5be42%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%20class%3D%22appliesTo%20collapsed%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22appliesTo%20collapsed%22%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%20class%3D%22appliesToItem%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ESo%20attached%20is%20a%20small%20file%20with%20an%20example.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%20class%3D%22appliesTo%20collapsed%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22appliesTo%20collapsed%22%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EInsert%20multiple%20data%20sources%20(worksheets)%20as%20a%20source%20with%20the%20PivotTable%20and%20PivotChart%20wizards.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EUnfortunately%2C%20it%20was%20banned%20from%20the%20menu%20ribbon%20at%20some%20point%20after%20XL%202003.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EHowever%2C%20it%20can%20still%20be%20activated%20today%2C%20depending%20on%20the%20Excel%20version.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3ECustomize%20it%20via%20the%20toolbar%20for%20quick%20access%20(right-click%20in%20the%20menu%20ribbon).%3C%2FSPAN%3E%20%3CSPAN%3ESearch%20for%20PivotTable%20and%20PivotChart%20Assistant%20under%20All%20Commands%20and%20transfer%20it%20to%20the%20toolbar.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ESince%20you%20did%20not%20name%20your%20operating%20system%20and%20Office%20version%2C%20this%20is%20also%20possible%20with%20older%20versions.%20Since%20you%20did%20not%20name%20your%20operating%20system%20and%20Office%20version%2C%20this%20is%20also%20possible%20with%20older%20versions.%20I'm%20not%20sure%20if%20the%20new%20versions%20have%20a%20different%20function%20or%20not.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EWith%20a%20possible%20activation%20it%20would%20look%20like%20this%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Pivot_2_sheet.JPG%22%20style%3D%22width%3A%20595px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223984iF8622CE48CAF65F9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Pivot_2_sheet.JPG%22%20alt%3D%22Old%20Pivot%20Option%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EOld%20Pivot%20Option%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ESelect%20the%20option%20marked%20in%20red%20and%20several%20tables%20can%20serve%20as%20a%20source.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22appliesTo%20collapsed%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a large amount of data that I am trying to pull into one pivot - the data is in two sheets and is an extension of the same data with the same headings but even after I have copied the data into one sheet (with over 115000 lines!) it wont pull through the data correctly 

Can anyone help please?

Thanks so much 

 

1 Reply
Highlighted

@Becskters 

 

Add worksheet data to a Data Model using a linked table