TABLE TOOLS AND PIVOT TABLE TOOLS

%3CLINGO-SUB%20id%3D%22lingo-sub-1613621%22%20slang%3D%22en-US%22%3ETABLE%20TOOLS%20AND%20PIVOT%20TABLE%20TOOLS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1613621%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20lost%20my%20table%20analysis%20and%20don't%20find%20the%20table%20tools%20either.%26nbsp%3B%20All%20the%20options%20are%20selected%20in%20the%20options.%26nbsp%3B%20I%20reinstalled%20the%2064%20bit%20to%20match%20my%20system%2C%20still%20isn't%20there.%26nbsp%3B%20I%20have%20the%20365%20Business%20subscription.%3C%2FP%3E%3CP%3ELinda%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LINDA1259_2-1598451261116.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214809iA802D744E62EAF41%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22LINDA1259_2-1598451261116.png%22%20alt%3D%22LINDA1259_2-1598451261116.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1613621%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1613767%22%20slang%3D%22en-US%22%3ERe%3A%20TABLE%20TOOLS%20AND%20PIVOT%20TABLE%20TOOLS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1613767%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660002%22%20target%3D%22_blank%22%3E%40LINDA1259%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETable%20Tools%20was%20depreciated%20in%20recent%20versions%20of%20Excel%2C%20that's%20Table%20Design%20appears%20if%20you%20stay%20within%20the%20table.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214819iEDDE472EA4D7916C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1613770%22%20slang%3D%22en-US%22%3ERe%3A%20TABLE%20TOOLS%20AND%20PIVOT%20TABLE%20TOOLS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1613770%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660002%22%20target%3D%22_blank%22%3E%40LINDA1259%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPivotTable%20Tools%20-%20please%20check%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fpivot-table-tools%2Fm-p%2F1300473%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fpivot-table-tools%2Fm-p%2F1300473%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1614101%22%20slang%3D%22en-US%22%3ERe%3A%20TABLE%20TOOLS%20AND%20PIVOT%20TABLE%20TOOLS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1614101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response.%26nbsp%3B%20I%20only%20have%20access%20to%20the%20design%20features%20with%20the%20tab%20you%20circled.%26nbsp%3B%20What%20I%20am%20missing%20is%20the%20ability%20to%20change%20the%20table%20at%20all.%26nbsp%3B%20I%20can't%20change%20the%20range%20or%20anything.%26nbsp%3B%20I%20started%20using%20power%20query%2C%20could%20that%20have%20eliminated%20any%20of%20my%20features%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1614108%22%20slang%3D%22en-US%22%3ERe%3A%20TABLE%20TOOLS%20AND%20PIVOT%20TABLE%20TOOLS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1614108%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%20this%20is%20what%20it%20shows%20me%20on%20internet%20for%20365%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LINDA1259_0-1598460147504.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214841iAE4D6946E7042BE5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22LINDA1259_0-1598460147504.png%22%20alt%3D%22LINDA1259_0-1598460147504.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1614194%22%20slang%3D%22en-US%22%3ERe%3A%20TABLE%20TOOLS%20AND%20PIVOT%20TABLE%20TOOLS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1614194%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660002%22%20target%3D%22_blank%22%3E%40LINDA1259%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENope%2C%20Power%20Query%20doesn't%20affect%20related%20to%20Tables%20part%20of%20ribbon%2C%20and%20in%20general%20everything%20is%20under%20Table%20Design%20in%20different%20section%20of%20ribbon.%20In%20particular%2C%20Resize%20Table%20is%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20373px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214846iB16157C594C10B37%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAs%20for%20the%20support%20page%20-%20it%20looks%20like%20it's%20bit%20outdated%2C%20I'll%20check%20with%20other%20people.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

 

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

 

LINDA1259_2-1598451261116.png

 

 

5 Replies

@LINDA1259 

Table Tools was depreciated in recent versions of Excel, that's Table Design appears if you stay within the table.

image.png

@Sergei Baklan 

 

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?

 

@Sergei Baklan  this is what it shows me on internet for 365 

LINDA1259_0-1598460147504.png

 

@LINDA1259 

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

image.png

As for the support page - it looks like it's bit outdated, I'll check with other people.