I don't think you can.

Maybe you could apply data|filter|autofilter to the original data and filter it
instead of drilling down through the pivottable.

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 database has different coloured lines, if I double click,
how can I keep the same lines coloured?

Thanks,
Assaf.

--

Dave Peterson