View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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