 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006AutoFilter May be Misbehaving
I have a worksheet, using 1845 rows and columns out to AB. We use the AutoFilter command on the Data menu constantly, and are getting a strange behaviour. When the filter is applied, it shows the appropriate data, but hides all the rows from 1845 down to 3606 and then displays the remaining from 3606 to 65536. What I can not figure out is why are rows 1845 to 3606 being hidden. There is nothing in them. To be sure of this, I selected all the rows from 1846 to 65536 and over to column IV and from the Edit menu, select Clear - Formats and then Clear - All, to no avail. What am I missing here? It is causing some difficulties with formulas on other worksheets linked to this sheet. Thank you Marsh I would try DELETING the entire rows from 1846 through 3700, then saving the workbook and open and try Autofilter again.......see if it acts the same. hth Vaya con Dios, Chuck, CABGx3 > I have a worksheet, using 1845 rows and columns out to AB. We use the > AutoFilter command on the Data menu constantly, and are getting a strange [quoted text clipped - 10 lines] > Thank you > Marsh I forgot to mention that I did that, to no avail. > I would try DELETING the entire rows from 1846 through 3700, then saving the > workbook and open and try Autofilter again.......see if it acts the same. [quoted text clipped - 17 lines] > > Thank you > > Marsh Try copying your data over to another workbook.....see if the problem follows. hth Vaya con Dios, Chuck, CABGx3 > I forgot to mention that I did that, to no avail. > [quoted text clipped - 19 lines] > > > Thank you > > > Marsh The effect did follow to a new worksheet!! It was worth a try. Any other suggestions are welcomed. > Try copying your data over to another workbook.....see if the problem follows. > [quoted text clipped - 25 lines] > > > > Thank you > > > > Marsh You may once have had data in the rows 1845 to 3606 and so the filter range is set to this, but as there is nothing in the cells on these rows, they are hidden when the filter is applied. Highlight rows 1845 down to the bottom of the sheet as you described earlier and use Edit | Delete to get rid of them (Edit|Clear will not). Your filter range should now only extend to row 1844. Hope this helps. Pete > The effect did follow to a new worksheet!! > It was worth a try. Any other suggestions are welcomed. [quoted text clipped - 28 lines] > > > > > Thank you > > > > > Marsh Maybe depends on how you do it..........if you copied the whole sheet, then try just copying the range of cells with data and pasteing them over to a new workbook...not the whole sheet, nor not entire rows or columns........I've had a few weird things occur to me before and this drastic move usually fixes them........... hth Vaya con Dios, Chuck, CABGx3 > The effect did follow to a new worksheet!! > It was worth a try. Any other suggestions are welcomed. [quoted text clipped - 28 lines] > > > > > Thank you > > > > > Marsh Since the offending data was all by data entry, all formulas were on other worksheets, I did a Paste Special/Values, having selected the range. This seems to have worked. Thank you both for you time and suggestions. Now to get to work on the calculations done on this data. Marsh > Maybe depends on how you do it..........if you copied the whole sheet, then > try just copying the range of cells with data and pasteing them over to a [quoted text clipped - 49 lines] > > > > > > Thank you > > > > > > Marsh
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.