Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
cycler
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
cycler
 
Posts: n/a
Default

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   Report Post  
gls858
 
Posts: n/a
Default

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   Report Post  
cycler
 
Posts: n/a
Default

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   Report Post  
gls858
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Ken Wright
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot open an xl97 file maxzsim Excel Discussion (Misc queries) 1 June 24th 05 12:29 PM
Excell 2000 - Cannot open file RustyC Excel Discussion (Misc queries) 2 March 4th 05 08:55 PM
Sumif Linking to Another Workbook error #VALUE! Tunde Excel Discussion (Misc queries) 16 March 4th 05 03:02 AM
Excel 2003 "File Open": how keep folders at top with sort by Date. Aging Analyst Excel Discussion (Misc queries) 1 December 3rd 04 03:26 AM
format question when open csv file Jeff Excel Discussion (Misc queries) 1 December 1st 04 06:53 PM


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"