Forum Discussion
DC619
Jun 25, 2019Copper Contributor
Pivot Tables- Drill down doesnt make table, creates data range
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
- JKPieterseSilver ContributorI 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.