I am using Excel 2010 and I have a worksheet with several columns (item#, item picture, item title). I am trying to sort these data by item # in descending order, everything sorted the way it should be EXCEPT the pictures. They DID NOT move at all. For example: the picture that was originally in cell B2 stayed in B2 even though its associated data moved to another row, the picture that was originally in cell B3 stayed in B3, etc. I made sure every picture fits inside its cell and no edge touches the border.
I have attached a sample workbook.
Can anyone help me with this?
P.S.
I tried it on my other machine that has Office 2007 installed and everything sorted correctly but when I try to do it again in Excel 2010, the pictures did not move at all.
Pictures wouldn't sort with its associated data
-
- NewLounger
- Posts: 5
- Joined: 05 Jan 2011, 21:29
- Location: New York, USA
Pictures wouldn't sort with its associated data
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Pictures wouldn't sort with its associated data
Hi xinvux,
Welcome to Eileen's Lounge!
I can confirm that the images sort correctly with the data in Excel 2007. I hope that someone with Excel 2010 will look at your sample workbook and have a suggestion.
Welcome to Eileen's Lounge!
I can confirm that the images sort correctly with the data in Excel 2007. I hope that someone with Excel 2010 will look at your sample workbook and have a suggestion.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 12629
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Pictures wouldn't sort with its associated data
Welcome from me too.HansV wrote: ...
I can confirm that the images sort correctly with the data in Excel 2007...
I can confirm that the images sort correctly with the data in Excel 2010, version 14.0.5128.5000 (32 bit).
Can you try starting Excel in safe mode and see if it works then (Just click the start button and type "excel /a" and then enter)
StuartR
-
- NewLounger
- Posts: 5
- Joined: 05 Jan 2011, 21:29
- Location: New York, USA
Re: Pictures wouldn't sort with its associated data
Nope, it did not work in Safe Mode either.
-
- Administrator
- Posts: 12629
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Pictures wouldn't sort with its associated data
Strange.xinvux wrote:Nope, it did not work in Safe Mode either.
Do you have the same version of Excel as I posted above (File > Help > Look on the right side of the screen)
StuartR
-
- NewLounger
- Posts: 5
- Joined: 05 Jan 2011, 21:29
- Location: New York, USA
Re: Pictures wouldn't sort with its associated data
I have version 14.0.4734.1000 (32-bit). I am guessing mine is an earlier version and that might be the cause of pictures not sorting correctly?
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Pictures wouldn't sort with its associated data
I doubt it, but it won't hurt to see if there are updates for Excel (Start > All Programs > Windows Update > Search for updates).
Best wishes,
Hans
Hans
-
- Microsoft MVP
- Posts: 656
- Joined: 24 Jan 2010, 17:51
- Status: Microsoft MVP
- Location: Weert, The Netherlands
Re: Pictures wouldn't sort with its associated data
What did you select EXACTLY prior to doing the sort?
-
- NewLounger
- Posts: 5
- Joined: 05 Jan 2011, 21:29
- Location: New York, USA
Re: Pictures wouldn't sort with its associated data
I tried selecting the whole range of data and sort, and i also tried selecting just the Item # on the top and sort. Both methods did not work on the pictures.
-
- NewLounger
- Posts: 5
- Joined: 05 Jan 2011, 21:29
- Location: New York, USA
Re: Pictures wouldn't sort with its associated data
Okay, I think I solved the problem!! I got desperate and I uninstalled and installed it and now it's working!! Thanks for everyone's help!!
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Pictures wouldn't sort with its associated data
Well, that was going to be the last-ditch suggestion. I'm glad it worked out well!
Best wishes,
Hans
Hans