Filter options disabled for pivot tables.

K

katokay

I am having an issue using filters on a pivot table in Excel 2007. All
filtering options are disabled in the menus except for Value Filters
Ideally we will be doing this on an AS2005 Cube, but I can't get it to
work for regular pivot tables built from Excel tables either.
 
K

katokay

I am having an issue using filters on a pivot table in Excel 2007. All
filtering options are disabled in the menus except for Value Filters


Ideally we will be doing this on an AS2005 Cube, but I can't get it to
work for regular pivot tables built from Excel tables either.
Click to expand...

One issue resolved. The manually created pivot tables can now filter.
I was in 2003 compatibility mode when I first posted. However, my
AS2005 Cube still has disabled menus.
 
K

katokay

One issue resolved. The manually created pivot tables can now filter.
I was in 2003 compatibility mode when I first posted. However, my
AS2005 Cube still has disabled menus.
Click to expand...

Issue was resolved after installing sp2 of sql server.
 

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

Menu Item Options -> Formulas Disabled for Pivot tables. 2
Update Filter List AFTER Filter Applied 3
Excel VBA For excel 0
How to base a pivot table on another pivot table? 3
PIvot Table top Values 1
working with pivot tables from another worksheet 2
Adding Report Filters to Excel Pivot Tables via VB. 1
pivot table date filters 2

Top