| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot tables value filter
I recently upgrade to excel 2007. The "allow multiple filter per field"
option is greyed out on a pivot table created in the prior version. How can I activate that option? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot tables value filter
Hi Tim
Save the file as an XL2007 file (either xlsx or xlsm if it has macros). Close then re-open. -- Regards Roger Govier "Tim" wrote in message ... I recently upgrade to excel 2007. The "allow multiple filter per field" option is greyed out on a pivot table created in the prior version. How can I activate that option? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to filter field button items in pivot tables | Charts and Charting in Excel | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Pivot Tables - filter out zero's? | Excel Discussion (Misc queries) | |||
| Customize Filter List in Pivot Tables | Excel Discussion (Misc queries) | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Linear Mode
