Issue with Autofilter and Pictures
 

I am having trouble keeping my pictures in their cells with the Autofilter
function. Some pictures will move. It mainly happens when I apply more than
1 filter.

Here's an example set up:
Date / Picture / Event / Print Date /# of copies needed / Copy given to
client 1/ copy given to client 2/client 3/

The pictures are all different sizes, I've put the setting on my 100
pictures that says move with cell and size with cell. It still moves. Then
I filter by Event, then print date and pictures stack on top at the bottom
(not all but some). I can have a few filters.

I saw a post already on this issue, but saw no real solution to this
situation.
Anyone else see the issue? Found a resolution?

Issue with Autofilter and Pictures
 

In my simple tests (in xl2003), the pictures behaved nicely.

Are you positive that the pictures are contained within the cell (or row).

Maybe showing the gridlines (tools|Options|view tab) would help verify this???

J_Mori wrote:

I am having trouble keeping my pictures in their cells with the Autofilter
function. Some pictures will move. It mainly happens when I apply more than
1 filter.

Here's an example set up:
Date / Picture / Event / Print Date /# of copies needed / Copy given to
client 1/ copy given to client 2/client 3/

The pictures are all different sizes, I've put the setting on my 100
pictures that says move with cell and size with cell. It still moves. Then
I filter by Event, then print date and pictures stack on top at the bottom
(not all but some). I can have a few filters.

I saw a post already on this issue, but saw no real solution to this
situation.
Anyone else see the issue? Found a resolution?

--

Dave Peterson

Issue with Autofilter and Pictures
 

My gridlines are defaulted to be on. I am also using xl2003. I am postive
that my pictures are contained within the cell/row. I made sure that the
perimeter pts (circles) for my 100+ pictures are in the cell. It took me a
while to do this. Most of the time the single filter works, but not always.
100% of the time when I filter for example by date and then copy given to
client 1 it starts to move to the bottom. If I unfilter it in the by copy
given to client 1 then date, the pictures sometimes move back.

Thanks for your input.

"Dave Peterson" wrote:

In my simple tests (in xl2003), the pictures behaved nicely.

Are you positive that the pictures are contained within the cell (or row).

Maybe showing the gridlines (tools|Options|view tab) would help verify this???

J_Mori wrote:

I am having trouble keeping my pictures in their cells with the Autofilter
function. Some pictures will move. It mainly happens when I apply more than
1 filter.

Here's an example set up:
Date / Picture / Event / Print Date /# of copies needed / Copy given to
client 1/ copy given to client 2/client 3/

The pictures are all different sizes, I've put the setting on my 100
pictures that says move with cell and size with cell. It still moves. Then
I filter by Event, then print date and pictures stack on top at the bottom
(not all but some). I can have a few filters.

I saw a post already on this issue, but saw no real solution to this
situation.
Anyone else see the issue? Found a resolution?

--

Dave Peterson

Issue with Autofilter and Pictures
 

I don't have any other guess that could help.

Good luck.

J_Mori wrote:

My gridlines are defaulted to be on. I am also using xl2003. I am postive
that my pictures are contained within the cell/row. I made sure that the
perimeter pts (circles) for my 100+ pictures are in the cell. It took me a
while to do this. Most of the time the single filter works, but not always.
100% of the time when I filter for example by date and then copy given to
client 1 it starts to move to the bottom. If I unfilter it in the by copy
given to client 1 then date, the pictures sometimes move back.

Thanks for your input.

"Dave Peterson" wrote:

In my simple tests (in xl2003), the pictures behaved nicely.

Are you positive that the pictures are contained within the cell (or row).

Maybe showing the gridlines (tools|Options|view tab) would help verify this???

J_Mori wrote:

I am having trouble keeping my pictures in their cells with the Autofilter
function. Some pictures will move. It mainly happens when I apply more than
1 filter.

Here's an example set up:
Date / Picture / Event / Print Date /# of copies needed / Copy given to
client 1/ copy given to client 2/client 3/

The pictures are all different sizes, I've put the setting on my 100
pictures that says move with cell and size with cell. It still moves. Then
I filter by Event, then print date and pictures stack on top at the bottom
(not all but some). I can have a few filters.

I saw a post already on this issue, but saw no real solution to this
situation.
Anyone else see the issue? Found a resolution?

--

Dave Peterson


--

Dave Peterson