hi,
i'm using filters in 2007, then i select range inorder to copy only the
filtered.
but actually it copy the full list.
in other computer, with 2003 it works. maybe it is a configrable problem.
any idea?
thanks,
--
Miri Tz.

I saw this response in another forum:

> The key here is that if you select just the table (or cells in the same rows
> as the table) to copy, then you will get the filtered data.
>
> If you select the filtered cells, plus data outside the table (the row
> above/below/both) then you will get the entire list (unfiltered).
>
> You can tell what you are going to get by looking at the "running ants"
> selection after pressing Ctrl+C. If you see only one area with the running
> ants around the outer perimeter, you are going to get the whole table. If
> you see several 'mini-selections' inside a larger bold border, then you will
> get the filtered data.



Miri wrote:
>
> hi,
> i'm using filters in 2007, then i select range inorder to copy only the
> filtered.
> but actually it copy the full list.
> in other computer, with 2003 it works. maybe it is a configrable problem.
> any idea?
> thanks,
> --
> Miri Tz.

--

Dave Peterson