| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open Pivot Data
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open Pivot Data
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Pivot | Excel Discussion (Misc queries) | |||
| Can't open pivot table field list | Excel Discussion (Misc queries) | |||
| Open excel pivot source data in Access? | Excel Discussion (Misc queries) | |||
| Cannot Open Pivot Table Source | Excel Discussion (Misc queries) | |||
| How to auto-refresh Pivot data when open Excel file? | Excel Worksheet Functions | |||
Linear Mode
