how to change the default sort order and file open dialogue box of Microsoft Excel 2010

[wormaji]

I have a computer program that frequently creates new files in a given directory. I then have to open the latest file in Microsoft Excel in that directory and work on it.


Whenever I do Ctrl+O and bring up the file open dialogue box, it brings up the list of files in the given directory with the oldest file at the top. That means I have to scroll all the way to the bottom to determine the newest file, and then open it.


I was able to change this behaviour in Microsoft Outlook where have the same requirement by doing control-click on the file open dialog box after making it sought in the descending order with the newest file at top. This was done by following the steps https://superuser.com/questions/495...rder-on-windows-explorer-and-the-file-dialogs.

However, this is not working for Microsoft Excel 2010. It did work for Microsoft Outlook 2010.So it is puzzling why did not work for Microsoft Excel 2010. I can anyone please provide a solution or some way to troubleshoot this? 'm using Windows 7 ultimate.Thank you for any inputs

 

[Yongle]

Clicking on Date Modified header toggles sort between ascending \ descending

 

[wormaji]

@Yongle. Thank you for your response. It looks like I did not properly framed the question. Sorry for that. I was looking for a solution where when I bring up the file dialogue box, the files are already sorted in the descending order of date modified. At present, it is bringing up the files in the ascending order of date modified. Even after I click on date modified header and and then toggle it to descending and then close the dialog box using a ctrl - mouse click on x at the top right hand corner, I still get the files sorted in ascending order of date when I get a new file dialogue box again.

So the question is how to get a file dialog box where the files are sorted in descending order of date modified by default in MS Excel 2010
Thank you for any inputs