Pivot Table

  • Thread starter Thread starter Brennan
  • Start date Start date
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
 
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 Refresh not working properly 1
Pivot Table Refresh? 1
date filter in a pivot table 1
Pivot Table - Changes 5
Pivot Table (column/row) label cache reset 4
How to refresh drop-down list of pivot table 3
Pivot table 1
How do I save Pivot Table Data 4

Back
Top