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