Keep pivot format
 

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.

Keep pivot format
 

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