Microsoft Office Forums Filter range

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2017, 09:44 PM
marif300 marif300 is offline Filter range Windows XP Filter range Office 2007
Advanced Beginner
Filter range
 
Join Date: Jun 2014
Location: Pakistan
Posts: 38
marif300 is on a distinguished road
Default Filter range

How to define filter range in MS project 2010, In my sheet, 11,000 rows inserted but data after 10,020 rows, doesn't appear in Auto filter.
Reply With Quote
  #2  
Old 03-24-2017, 03:19 AM
JulieS JulieS is offline Filter range Windows 10 Filter range Office 2016
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Not sure I understand - are you saying the filter won't return more than 10,020 rows or that the selections don't appear in the autofilter drop down? Can you get what you need through a traditional custom filter?
Reply With Quote
  #3  
Old 04-22-2017, 03:44 AM
marif300 marif300 is offline Filter range Windows XP Filter range Office 2007
Advanced Beginner
Filter range
 
Join Date: Jun 2014
Location: Pakistan
Posts: 38
marif300 is on a distinguished road
Default

I generated new sheet and filter shows complete data. I don't understand, what was the issue in previous sheet, may be some customization issue occurred. Thanks for your feedback.
Reply With Quote
  #4  
Old 05-05-2017, 02:39 PM
JulieS JulieS is offline Filter range Windows 10 Filter range Office 2016
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You may have a corrupt view. Try resetting to default.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter range Filter Mail Merge based on a list of filter criteria AusSteelMan Mail Merge 2 05-09-2016 03:35 PM
Filter range Name a Range in a Word Document and then copy that range to the end of the doc w button click DanNatCorning Word VBA 1 04-29-2016 10:47 PM
Filter range Filter by a Month that falls within a date range MattG1225 Excel 2 12-03-2015 07:44 AM
Filter range Data validation list filter with range defined by OFFSET Mango123 Excel 4 03-18-2014 02:52 PM
Range Name in Adv Filter -> NOt working 56_kruiser Excel 2 11-20-2012 09:58 AM


All times are GMT -7. The time now is 01:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft