ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Not filtering entire Database (https://www.excelbanter.com/excel-worksheet-functions/34521-not-filtering-entire-database.html)

Katie

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!!

Anne Troy

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!!




Dave Peterson

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


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com