Question Locked
Excel Pivot Table
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Excel Pivot Table ? Selected Items
Why Excel does not keep the same selected items in the pivot table?
For instance, my pivot table selects just the accounts that are Asset Accounts. I mark just the accounts that I want in the drop down list items. Well when I refresh the pivot table it always adds other accounts that I do not want to see. What I notice is those accounts where not showing in the data base when I first build the pivot table.
How can I keep just the selected items?