If anyone can help, that would be great.
Mail back if further help is needed,
Hello, I have files saved in Excel that I would like to have opened in alphabetical order but Excel 2010 seems to open them in a random order ...
You must choose the location from File > Open and browse to the file to open it. After you've opened the file from its new location, that link is added to the list.
trying to import excel which is still open in excel; OS X File associations finally fixed!
On your Mac, click the Finder icon in the Dock to open a Finder window.
This example sorts the files and subdirectories in a directory.
bioinformatics.bethematchclinical.org
Should you export this file from Excel (e.g., to a database), please note that
Learn how to sort Excel data by multiple columns, by column names and by values in any row. How to sort data in custom order when sorting alphabetically does not
To list all the files in a folder you could use VBA or PowerQuery. But you could also use the little known FILES function.