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...
JKPieterse
Jun 26, 2019Silver Contributor
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.