Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why doesn't the File Open list sort into filename order?
In Excel in a certain directory, when using "File" "open", the file list can
not appear to be capable of sorting into alpha order by clicking the "name" column header. This is very inconvenient because it is a shared directory and other users report files missing when they are actually in the list elsewhere. |
#2
|
|||
|
|||
Are you sure you're showing details in that dialog?
cycler wrote: In Excel in a certain directory, when using "File" "open", the file list can not appear to be capable of sorting into alpha order by clicking the "name" column header. This is very inconvenient because it is a shared directory and other users report files missing when they are actually in the list elsewhere. -- Dave Peterson |
#3
|
|||
|
|||
What more details would be needed to clarify this?
"Dave Peterson" wrote: Are you sure you're showing details in that dialog? cycler wrote: In Excel in a certain directory, when using "File" "open", the file list can not appear to be capable of sorting into alpha order by clicking the "name" column header. This is very inconvenient because it is a shared directory and other users report files missing when they are actually in the list elsewhere. -- Dave Peterson |
#4
|
|||
|
|||
cycler wrote:
What more details would be needed to clarify this? "Dave Peterson" wrote: Are you sure you're showing details in that dialog? cycler wrote: In Excel in a certain directory, when using "File" "open", the file list can not appear to be capable of sorting into alpha order by clicking the "name" column header. This is very inconvenient because it is a shared directory and other users report files missing when they are actually in the list elsewhere. -- Dave Peterson in the Open dialog box there is an icon for views set it to Details I believe this is what Dave was referring to. gls858 |
#5
|
|||
|
|||
Thank you but the details icon, or the list icon, doesn't improve the sort.
All the filenames are numeric or alpha-numeric Would this be a factor? "gls858" wrote: cycler wrote: What more details would be needed to clarify this? "Dave Peterson" wrote: Are you sure you're showing details in that dialog? cycler wrote: In Excel in a certain directory, when using "File" "open", the file list can not appear to be capable of sorting into alpha order by clicking the "name" column header. This is very inconvenient because it is a shared directory and other users report files missing when they are actually in the list elsewhere. -- Dave Peterson in the Open dialog box there is an icon for views set it to Details I believe this is what Dave was referring to. gls858 |
#6
|
|||
|
|||
cycler wrote:
Thank you but the details icon, or the list icon, doesn't improve the sort. All the filenames are numeric or alpha-numeric Would this be a factor? "gls858" wrote: cycler wrote: What more details would be needed to clarify this? "Dave Peterson" wrote: Are you sure you're showing details in that dialog? cycler wrote: In Excel in a certain directory, when using "File" "open", the file list can not appear to be capable of sorting into alpha order by clicking the "name" column header. This is very inconvenient because it is a shared directory and other users report files missing when they are actually in the list elsewhere. -- Dave Peterson in the Open dialog box there is an icon for views set it to Details I believe this is what Dave was referring to. gls858 Once you display the details you can click on Name and the top of the col it should toggle A-Z or Z-A note that folder are sorted separately. gls858 |
#7
|
|||
|
|||
But if you show the details (by clicking on View|details), then you can click on
the Name header to sort. At least it always works that way for me. cycler wrote: Thank you but the details icon, or the list icon, doesn't improve the sort. All the filenames are numeric or alpha-numeric Would this be a factor? "gls858" wrote: cycler wrote: What more details would be needed to clarify this? "Dave Peterson" wrote: Are you sure you're showing details in that dialog? cycler wrote: In Excel in a certain directory, when using "File" "open", the file list can not appear to be capable of sorting into alpha order by clicking the "name" column header. This is very inconvenient because it is a shared directory and other users report files missing when they are actually in the list elsewhere. -- Dave Peterson in the Open dialog box there is an icon for views set it to Details I believe this is what Dave was referring to. gls858 -- Dave Peterson |
#8
|
|||
|
|||
At least it always works that way for me.
Ditto :-) "Dave Peterson" wrote in message ... But if you show the details (by clicking on View|details), then you can click on the Name header to sort. At least it always works that way for me. cycler wrote: Thank you but the details icon, or the list icon, doesn't improve the sort. All the filenames are numeric or alpha-numeric Would this be a factor? "gls858" wrote: cycler wrote: What more details would be needed to clarify this? "Dave Peterson" wrote: Are you sure you're showing details in that dialog? cycler wrote: In Excel in a certain directory, when using "File" "open", the file list can not appear to be capable of sorting into alpha order by clicking the "name" column header. This is very inconvenient because it is a shared directory and other users report files missing when they are actually in the list elsewhere. -- Dave Peterson in the Open dialog box there is an icon for views set it to Details I believe this is what Dave was referring to. gls858 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot open an xl97 file | Excel Discussion (Misc queries) | |||
Excell 2000 - Cannot open file | Excel Discussion (Misc queries) | |||
Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
Excel 2003 "File Open": how keep folders at top with sort by Date. | Excel Discussion (Misc queries) | |||
format question when open csv file | Excel Discussion (Misc queries) |