Pivot Table

B

Brennan

Hello,

I have a pivot table and I will add data periodically and then refresh the
entire table, which works. The problem exists when I use one of the pull
down criteria boxes. They were alphbetized at first, but now all of the new
entries from newer data just fall to the bottom of the drop down. Is there a
way to have those alphabetized with each new data entry? Thanks for your
help. I appreciate it.

B
 
D

Debra Dalgleish

To sort the items in the dropdown list, you can sort the field:
Double-click the field button, and click Advanced.
Under AutoSort options, click on Ascending or Descending
 

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

Pivot Table - Changes 5
Pivot table 1
Pivot Table Refresh? 1
Pivot table drop downs not refreshing 1
Pivot table data 3
Pivot Table Help! 1
Pivot table 1
Pivot Table New Data 4

Top