We have several pivot tables using the Add-in where when selecting a cell to drill-thru for details will only provide the date by default as a number.
We must reformat it in the worksheet each time to display the date properly.
If the variable is display in the pivot table, it is displayed as date.
What is missing to enable auto formatting for the cell drill-thru detail to provided date variables as dates ?
What format (or not) should the date variables be ?
We have contacted tech support on this question and never recieved an response that has solved our problem.
Message was edited by: jrmathieu