Home

Excel 2016 table won't pivot

%3CLINGO-SUB%20id%3D%22lingo-sub-875917%22%20slang%3D%22en-US%22%3EExcel%202016%20table%20won't%20pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875917%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20this%20is%20probably%20simple%20but%20I'm%20missing%20it...%3C%2FP%3E%3CP%3EI%20created%20a%20sample%20table%20for%20the%20data%20file%20I%20want%20to%20create%20a%20pivot%20table%20for%20and%20go%20the%20report%20just%20right%20with%20no%20issues.%26nbsp%3B%20But%20now%20when%20I%20have%20the%20real%20data%20file%20ready%2C%20I%20can't%20get%20the%20Insert%20tab%20to%20allow%20a%20pivot%20table%20(it's%20greyed).%26nbsp%3B%20I%20don't%20have%20blank%20columns%20or%20rows%3B%20I%20have%20a%201%20row%20heading%20row.%26nbsp%3B%20There%20are%20some%20blank%20cells%20here%20and%20there%20but%20I%20had%20same%20in%20the%20sample%20table...and%20they%20aren't%20cells%20used%20in%20the%20results.%26nbsp%3B%20Sample%20pivots%2C%20real%20data%20table%20will%20not.%26nbsp%3B%20What%20else%20can%20it%20be%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-875917%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876034%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20table%20won't%20pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415385%22%20target%3D%22_blank%22%3E%40Mowreyuser%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20workbook%20is%20protected.%3C%2FP%3E%3CP%3EYour%20worksheet%20is%20protected.%3C%2FP%3E%3CP%3EYou%20have%20grouped%20worksheets.%3C%2FP%3E%3CP%3Etbc-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Mowreyuser
Occasional Visitor

I think this is probably simple but I'm missing it...

I created a sample table for the data file I want to create a pivot table for and go the report just right with no issues.  But now when I have the real data file ready, I can't get the Insert tab to allow a pivot table (it's greyed).  I don't have blank columns or rows; I have a 1 row heading row.  There are some blank cells here and there but I had same in the sample table...and they aren't cells used in the results.  Sample pivots, real data table will not.  What else can it be? 

1 Reply

@Mowreyuser 

Your workbook is protected.

Your worksheet is protected.

You have grouped worksheets.

tbc-

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies