Excel: FILES() Function Returns Files in FAT Order

ID: Q48145

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0

SUMMARY

The Excel FILES() command does not sort files by date, alphabetically, or by file size. It sorts based on the way files are listed in the file allocation table (FAT). An identical list can be obtained by executing a DOS-level directory listing of the same directory.

Additional query words:

Keywords :
Version :
Platform :
Issue type :