Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Not filtering entire Database
I have Windows and Office XP and am having problems using my filter function
in excel. The entire database will be highlighted yet once the filter function is on everything is not showing up in the drop down menu. I am dealing with large databases 10k-30k lines with data but I would only assume there isn't a maximum filteration number. All updates are up to date and I even reloaded Office. Thank you!! |
#2
|
|||
|
|||
See this, Katie:
http://support.microsoft.com/default...;en-us;Q295971 ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Katie" wrote in message ... I have Windows and Office XP and am having problems using my filter function in excel. The entire database will be highlighted yet once the filter function is on everything is not showing up in the drop down menu. I am dealing with large databases 10k-30k lines with data but I would only assume there isn't a maximum filteration number. All updates are up to date and I even reloaded Office. Thank you!! |
#3
|
|||
|
|||
Debra Dalgleish has some workarounds at:
http://www.contextures.com/xlautofilter02.html#Limits Katie wrote: I have Windows and Office XP and am having problems using my filter function in excel. The entire database will be highlighted yet once the filter function is on everything is not showing up in the drop down menu. I am dealing with large databases 10k-30k lines with data but I would only assume there isn't a maximum filteration number. All updates are up to date and I even reloaded Office. Thank you!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy database to another sheet | Excel Worksheet Functions | |||
multiple items in database | Excel Worksheet Functions | |||
The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) | |||
avanced filtering for latest date | Excel Discussion (Misc queries) | |||
Graphing Database Growth Rate | Charts and Charting in Excel |