| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a worksheet with embedded documents in one column
I need to sort a worksheet that has Word, Powerpoint and Mail Messages
embedded in one column and displayed as icons, using criteria in some of the other columns. Attempting to do this seems to result in the embedded files being redistributed on the worksheet. Is there a way to lock the embedded files to the data in the rows so that the relationships are preserved after sorting? Any help greatly appreciated! -- John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting a worksheet with embedded documents in one column
Excel 2003
Right click on the object Choose Format Objects|Properties Select 'Don't move or size with cells' "JHQ" wrote: I need to sort a worksheet that has Word, Powerpoint and Mail Messages embedded in one column and displayed as icons, using criteria in some of the other columns. Attempting to do this seems to result in the embedded files being redistributed on the worksheet. Is there a way to lock the embedded files to the data in the rows so that the relationships are preserved after sorting? Any help greatly appreciated! -- John |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting a worksheet with embedded documents in one column
Thanks Sheloo, that helped identify where the problem lay and it works now.
BR John -- John "Sheeloo" wrote: Excel 2003 Right click on the object Choose Format Objects|Properties Select 'Don't move or size with cells' "JHQ" wrote: I need to sort a worksheet that has Word, Powerpoint and Mail Messages embedded in one column and displayed as icons, using criteria in some of the other columns. Attempting to do this seems to result in the embedded files being redistributed on the worksheet. Is there a way to lock the embedded files to the data in the rows so that the relationships are preserved after sorting? Any help greatly appreciated! -- John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| embedded documents in excel | Excel Discussion (Misc queries) | |||
| Coping Embedded documents to local drive... | Excel Discussion (Misc queries) | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
| Can I convert linked into embedded documents in Excel 2003? | Excel Discussion (Misc queries) | |||
| Sorting excel document containing embedded pdfs | Excel Discussion (Misc queries) | |||
Linear Mode
