I have converted an Excel 2010 powerpivot workbook to Excel 2013. It seems to work ok except that as far as i can tell it has put all the imported fields and calculated column fields for one table into a subfolder called "more fields" under my table name "transactions. All the calculated fields are listed directly under "transactions". Oddly it hasn't done this on any of my other tables. Reading around this seems to be something to do with field attributes. Having some fields in the root of "transactions" and some in a subfolder is extremely confusing so really need to get everything in the root so it can be in alphabetical order like it was in 2010. Does anyone know how to change the field attributes so the "more fields" folder disappears please???
Really appreciate any advice.
Mike
Really appreciate any advice.
Mike
