yes - it sits on the public drive on our network.
--
Peter


"Peo Sjoblom" wrote:

Is the workbook shared?

--
Regards,

Peo Sjoblom



"Peter" wrote in message
...
Hi,
Thanks but "show all" is greyed out
--
Peter


"Peo Sjoblom" wrote:

To remove advanced filters do datafiltershow all


--
Regards,

Peo Sjoblom


"Peter" wrote in message
...
We have been happily using auto filter on a spreadsheet for months.
Recently
we noticed that the auto filter wasn't covering the bottom few rows.
After
a
bit of searching around I found advanced filter which had information
in
the
"list range" box. The auto filter was only working to the extent of the
range
in the advanced filter.
How do I get rid of this range. If I delete it it says reference is not
valid. If I type in a bigger range to cope with growth in the
spreadsheet
it
does not retain it.
The spreadsheet is used by several users on a network.
I tried copying the data to a new spreadsheet but the problem has just
followed.
Any ideas?

--
Peter