No, the extracted data won't retain the formatting from the pivot table.
There's no setting that will change this behaviour.

assaf1978 wrote:
Hi,
When double clicking a field in a pivot table, it opens the original data.
Is there a way to keep the format the data is in?
Let's say, if the pivot has different coloured lines, if I double click,
how can I keep the same lines coloured?

Thanks,
Assaf.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com