Keep pivot format

A

assaf1978

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.
 
D

Debra Dalgleish

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Pivot Data 1
A Pivot question 1
about pivot table 1
Pivot table filter list - listing irrelevant subcategorys 1
keep the pivot data format 2
One pivot table for multiple worksheets/tabs 2
Pivot Table date format 1
Format Extracted Data from Pivot Table 2

Top