Hi I am trying to utilize a pivot table but it appears the recommended table list will not show up. I can go back to a different file and it shows up. Even when I copy the other table into the current excel sheet the recommended list appears but only for that table. When I try to click on the recommended pivot table from my new table it gives an error message that there are too many blank cells. anyone have this problem or have a fix for it. I have some snapshots below.
Excel Version 2104
OS Windows 10
