Forum Discussion
TABLE TOOLS AND PIVOT TABLE TOOLS
I lost my table analysis and don't find the table tools either. All the options are selected in the options. I reinstalled the 64 bit to match my system, still isn't there. I have the 365 Business subscription.
Linda
5 Replies
PivotTable Tools - please check here https://techcommunity.microsoft.com/t5/excel/pivot-table-tools/m-p/1300473
Table Tools was depreciated in recent versions of Excel, that's Table Design appears if you stay within the table.
Thank you for your response. I only have access to the design features with the tab you circled. What I am missing is the ability to change the table at all. I can't change the range or anything. I started using power query, could that have eliminated any of my features?
Nope, Power Query doesn't affect related to Tables part of ribbon, and in general everything is under Table Design in different section of ribbon. In particular, Resize Table is here
As for the support page - it looks like it's bit outdated, I'll check with other people.
