Hi All,
I'm recreating a pivot tables source data by double clicking on the results row. Everything works fine except that the data shown is formated in a custom format and I need it to be displayed automatically in general format for final users, so I cannot use VBA or change it myself by hand.
I've already tried creating a Template worksheet, but this only works in new worksheets and doesn't apply to the creation of a worksheet by double clicking on a pivot table.
Does anyone know how to make the data appear automatically in general format (as it always used to)? It would also be helpful if someone knew why this is happening as to prevent it from happening again.
Thanks,
I'm recreating a pivot tables source data by double clicking on the results row. Everything works fine except that the data shown is formated in a custom format and I need it to be displayed automatically in general format for final users, so I cannot use VBA or change it myself by hand.
I've already tried creating a Template worksheet, but this only works in new worksheets and doesn't apply to the creation of a worksheet by double clicking on a pivot table.
Does anyone know how to make the data appear automatically in general format (as it always used to)? It would also be helpful if someone knew why this is happening as to prevent it from happening again.
Thanks,