This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Trying to create a pivot table from a workbook with 3 worksheets, each sheet contains data downloaded from financial website into a excel file. Each worksheet has the same number of columns and names, formatted as a table. I can create a pivot table using any one of the worksheets and it works just fine, all categories and totals for each. I open the wizard and try to create a pivot table from the data on each of the three work sheets, copying the range of the entire table from each, and it will not work correctly. I have maybe 20 different categories listed across the worksheets, but the pivot table will only pick up 3-5 of them. Can someone tell me what may look for to correct this? I have searched help files, watched videos and as far as I can tell I'm adding the correct data but can't get it to work correctly
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
Try the steps outlined in the video here - https://www.youtube.com/watch?v=yL11ugShdrk
Sorry for the delay, I have tried to follow the directions and I can't seem to get it to work correctly. I can create the pivot table from one sheet and it works just fine, it is when I try to create with 2 or 3 sheets it fails. I get a pivot table but only part of the data(categories) appears. Thanks for your help, I'm going to try a couple more ideas I have.
Sorry for the delay, I have tried to follow the directions and I can't seem to get it to work correctly. I can create the pivot table from one sheet and it works just fine, it is when I try to create with 2 or 3 sheets it fails. I get a pivot table but only part of the data(categories) appears. Thanks for your help, I'm going to try a couple more ideas I have.
Hi Keith_FI
Greetings! I am Vijay, an Independent Advisor. Press ALT+D+P to consolidate the data in a single place. If this consolidation doesn't work for you, then you can try to create a pivot on this consolidated pivot.
But right solution for you would be Power pivot but this has its own learning curve. You can search on youtube for learning videos on this,.
Do let me know if you have any more question or require further help.
Hi,
You may refer to my solution here - Create a Pivot Table from multiple worksheets in the same workbook.
Hope this helps.