Thread: Open Pivot
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
assaf1978 assaf1978 is offline
external usenet poster
 
Posts: 30
Default Open Pivot

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.