Sorting Images in Excel 2007

[Lis]

I have created for a client a Reporting Services report that includes images.
When I export the report from Reporting Services into Excel 2003 and then
sort, the images sort along with the data. However, in Excel 2007, the
images do not sort. I have created some instructions for the client on what
to do in order to get the images to sort, but the client is not happy. What
is different from 2007 to 2003? Does anyone have any suggestions that can
allow the exported Reporting Services report to sort images in Excel 2007
right out of the box?

Here is what I have to do now to get them to sort. 9 steps is a bit
daunting to the client:

1. Click on any one of the images.
2. Hit Ctrl-Shift-Spacebar on your keyboard. This will select all of the
images.
3. Right-click on one of the images and choose “Size and Propertiesâ€
4. Click on the Properties Tab
5. Choose “Move but Don’t Size With Cellsâ€
6. Click on the Size Tab
7. Under “Size and Rotateâ€, change Height from 0.7†to 0.6â€. You can do
this by clicking once on the down arrow next to the size.
8. Click the close button
9. Click into the Mark Column
10. On the toolbar, choose Data
11. You can now sort and the images will sort with the data.


Thanks in advance for any help.

 

[Joel]

This code will do the same as your manual steps

Sub FixPicture()
'
' Macro1 Macro
' Macro recorded 8/7/2009 by Joel
'
For Each shp In ActiveSheet.Shapes
shp.Placement = xlMove
shp.Height = 0.6

Next shp

End Sub

 

[Lis]

Thanks. That is a bit better than giving them all those steps, but I still
have the issue that the people using the report are all over the place. I
don't have access to their machines, and I don't know how to build a macro
into the excel sheet that Reporting Services spits out. Is there something I
can have them do in Excel 2007 that will make it behave like Excel 2003?

 

[Joel]

I'm not an expert on registry but the may be a setting that will do this.
Maybe the better solution is to distrute the file as 2007 (xlsx) and make the
2003 users download the microsoft to that allows them to use xlsx files. Or
distribute the fil as both 2003 and 2007.

 

[Lis]

Thanks, Joel.