Sharepoint List Drop Down filter issue

I have a Sharepoint 2007 server and we currently have a CRM List that contains customer names, numbers, address, information, attachments, etc...

When you click on the CRM LIST on the left hand side of Sharepoint it brings it up in the All Items View. There is nothing special to this view, its just the standard.

Now above we have our normal NEW - ACTIONS - SETTINGS drop downs and below that is the TITLE COLUMN for the list.

Each Title in every Column in the list has a Name (ie. Address, Customer name, Phone number, etc... )

When you click on that top Column Name it opens a menu showing you can sort by Acsending and Decsending also below that it shows the Data in that Column (ie. customer name = shows all of our customers) and you can click on a customer your looking for and fliter it to that Customer Name.

However that is no longer an option, when you click on the Column Title it just shows Acsending and Decsending and Show Filter Choices. It no longer shows the Data within that column.

But if I click on the Phone number column it does show the data in that column and I can pick which number I want and filter it like that.

So why is it just affecting certain columns?
Neogeo147IT Systems AdminAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MontoyaProcess Improvement MgrCommented:
did you make any changes to the content type?
Neogeo147IT Systems AdminAuthor Commented:
not that I know of, I know there are several people that go in there, what do you mean by content type? it is just single line text
MontoyaProcess Improvement MgrCommented:
Also, do you have the same behavior if you do this:  

add ?filter=1 at the end of your URL.. after the aspx
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

MontoyaProcess Improvement MgrCommented:
another thing to check is if your list is going beyond 500 items. I read somewhere that it causes issues w/ List filter

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Neogeo147IT Systems AdminAuthor Commented:
Actually I think we just hit 505 as of Friday or Monday, Today is when the user noticed it so that could be it, some sort of Threshold
Neogeo147IT Systems AdminAuthor Commented:
Yup thats it, I removed about 20 entries and now it works, Thank you for helping me figure this out, I hate the little things users come up with but at least theres documentation for it now.

Thank you again
Neogeo147IT Systems AdminAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for Neogeo147's comment #a40409146

for the following reason:

Spot on, removed some entries and it came back
MontoyaProcess Improvement MgrCommented:
I dont understand why you are posting a close request and not awarding points, when the answer was spot on. Perhaps by mistake?
Neogeo147IT Systems AdminAuthor Commented:
Yeah that's wierd it said 500, I'll take a look see why, I selected the grade, this new system is different
Neogeo147IT Systems AdminAuthor Commented:
there ya go
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.