| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
AutoFilter 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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
AutoFilter May be Misbehaving
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 "Marsh" wrote: 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
AutoFilter May be Misbehaving
I forgot to mention that I did that, to no avail.
"CLR" wrote: 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 "Marsh" wrote: 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
AutoFilter May be Misbehaving
Try copying your data over to another workbook.....see if the problem follows.
hth Vaya con Dios, Chuck, CABGx3 "Marsh" wrote: I forgot to mention that I did that, to no avail. "CLR" wrote: 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 "Marsh" wrote: 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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
AutoFilter May be Misbehaving
The effect did follow to a new worksheet!!
It was worth a try. Any other suggestions are welcomed. "CLR" wrote: Try copying your data over to another workbook.....see if the problem follows. hth Vaya con Dios, Chuck, CABGx3 "Marsh" wrote: I forgot to mention that I did that, to no avail. "CLR" wrote: 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 "Marsh" wrote: 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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
AutoFilter May be Misbehaving
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 Marsh wrote: The effect did follow to a new worksheet!! It was worth a try. Any other suggestions are welcomed. "CLR" wrote: Try copying your data over to another workbook.....see if the problem follows. hth Vaya con Dios, Chuck, CABGx3 "Marsh" wrote: I forgot to mention that I did that, to no avail. "CLR" wrote: 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 "Marsh" wrote: 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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
AutoFilter May be Misbehaving
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 "Marsh" wrote in message ... The effect did follow to a new worksheet!! It was worth a try. Any other suggestions are welcomed. "CLR" wrote: Try copying your data over to another workbook.....see if the problem follows. hth Vaya con Dios, Chuck, CABGx3 "Marsh" wrote: I forgot to mention that I did that, to no avail. "CLR" wrote: 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 "Marsh" wrote: 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 |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
AutoFilter May be Misbehaving
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 "CLR" wrote: 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 "Marsh" wrote in message ... The effect did follow to a new worksheet!! It was worth a try. Any other suggestions are welcomed. "CLR" wrote: Try copying your data over to another workbook.....see if the problem follows. hth Vaya con Dios, Chuck, CABGx3 "Marsh" wrote: I forgot to mention that I did that, to no avail. "CLR" wrote: 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 "Marsh" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter using the contents of a particular cell | Excel Discussion (Misc queries) | |||
| Applying an AutoFilter to a string | Excel Discussion (Misc queries) | |||
| How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
| Using AutoFilter with worksheet protection in 2000 vs. 2003 | Excel Discussion (Misc queries) | |||
| Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
Linear Mode
