Home

Pivot Tables- Drill down doesnt make table, creates data range

%3CLINGO-SUB%20id%3D%22lingo-sub-720296%22%20slang%3D%22en-US%22%3EPivot%20Tables-%20Drill%20down%20doesnt%20make%20table%2C%20creates%20data%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-720296%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20click%20into%20a%20cell%20in%20my%20pivot%20table%20it%20creates%20a%20new%20worksheet%20with%20a%20data%20range%20instead%20of%20a%20table.%20I'm%20confused%20since%20based%20on%20the%20research%20I've%20done%2C%20the%20default%20setting%20should%20be%20to%20make%20a%20table.%20I%20created%20a%20new%20excel%20file%20and%20it%20seemed%20to%20work%20but%20I%20went%20to%20refresh%20my%20data%20and%20then%20the%20pivot%20table%20just%20spits%20out%20the%20data%20range%20again%2C%20no%20table.%20I'm%20thinking%20when%20I%20copy%20and%20paste%20my%20new%20data%20into%20the%20spreadsheet%20its%20doing%20something%20to%20alter%20it%2C%20but%20I%20have%20no%20idea%20how%20to%20fix%20this.%20Does%20the%20data%20for%20the%20pivot%20table%20need%20to%20be%20formatted%20a%20certain%20way%3F%20Can%20someone%20please%20help%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-720296%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-721157%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Tables-%20Drill%20down%20doesnt%20make%20table%2C%20creates%20data%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-721157%22%20slang%3D%22en-US%22%3EI%20think%20the%20file%20in%20question%20is%20saved%20to%20an%20ancient%20file%20format%20(.xls)%2C%20forcing%20Excel%20in%20to%20compatibility%20mode%20for%20the%20%22newest%22%20version%20that%20used%20that%20format%20as%20the%20default%3A%20Excel%202003.%3C%2FLINGO-BODY%3E
DC619
Occasional Visitor

When I click into a cell in my pivot table it creates a new worksheet with a data range instead of a table. I'm confused since based on the research I've done, the default setting should be to make a table. I created a new excel file and it seemed to work but I went to refresh my data and then the pivot table just spits out the data range again, no table. I'm thinking when I copy and paste my new data into the spreadsheet its doing something to alter it, but I have no idea how to fix this. Does the data for the pivot table need to be formatted a certain way? Can someone please help? 

 

Thanks!

1 Reply
I think the file in question is saved to an ancient file format (.xls), forcing Excel in to compatibility mode for the "newest" version that used that format as the default: Excel 2003.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies