AutoFilter May be Misbehaving

[Guest]

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

 

[Guest]

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

 

[Guest]

I forgot to mention that I did that, to no avail.

 

[Guest]

Try copying your data over to another workbook.....see if the problem follows.

hth
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

The effect did follow to a new worksheet!!
It was worth a try. Any other suggestions are welcomed.

 

[Pete_UK]

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

 

[CLR]

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

 

[Guest]

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