Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I recently upgraded to office 2007 and I have a problem with an excel file
that works fine in excel 2003. I have a list with pictures and other various attributes. When I sort by one of the attributes, the picture doesn't move with its respective row. I am doing a simple "A to Z sort". Like I said, the list works fine in excel 2003, but not excel 2007 for some reason. Anybody know what's going on? Any help is much appreciated. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Eric
I have a list with pictures and information. The pictures are all the same size and fit into a resized cell which is square in size (bit larger than thumbnail) Right click on a picture. Select Format Picture. Propertises. Click on "Move and Size with Cells". I run three Macro's to sort by Brand, Place Purchased and Item's Model Number. HTH -- Thank you Bob C It costs little to carry knowledge with you. "Eric" wrote: I recently upgraded to office 2007 and I have a problem with an excel file that works fine in excel 2003. I have a list with pictures and other various attributes. When I sort by one of the attributes, the picture doesn't move with its respective row. I am doing a simple "A to Z sort". Like I said, the list works fine in excel 2003, but not excel 2007 for some reason. Anybody know what's going on? Any help is much appreciated. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Eric
Sorry just noticed your using Office 2007. I'm not familier with it. Perhaps the object (pictures) propertises has not come across. -- Bob C It cost''''''''s little to carry knowledge with you. "Bob C" wrote: Eric I have a list with pictures and information. The pictures are all the same size and fit into a resized cell which is square in size (bit larger than thumbnail) Right click on a picture. Select Format Picture. Propertises. Click on "Move and Size with Cells". I run three Macro's to sort by Brand, Place Purchased and Item's Model Number. HTH -- Thank you Bob C It costs little to carry knowledge with you. "Eric" wrote: I recently upgraded to office 2007 and I have a problem with an excel file that works fine in excel 2003. I have a list with pictures and other various attributes. When I sort by one of the attributes, the picture doesn't move with its respective row. I am doing a simple "A to Z sort". Like I said, the list works fine in excel 2003, but not excel 2007 for some reason. Anybody know what's going on? Any help is much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto updating list | Excel Worksheet Functions | |||
Sort text list by character length - how? | Excel Worksheet Functions | |||
Sort a list with uneven row information | Excel Worksheet Functions | |||
custom list does not sort | Excel Worksheet Functions | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) |