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
|