Hi,


I have a listFiles named range to return a list of files of a specific folder into Excel. I use the following formula: =IFERROR(INDEX(listFiles,ROW()-ROW(A$2)),"")
I was wondering if there is a non-VBA solution to automatically/live update the files list in the Excel named range whenever a file in the folder gets added, deleted or modified.
Moreover, is there an Excel formula to alphanumerically sort these files dynamically/live?