Sorting Excel Files by "Last Modified By" Parameter

Question

How do you sort Excel files by "Last Modified By"?  I have thousands of Excel files with two types co-mingled.  We need to separate them without having to open each one separately.  The only distinguishing difference is that one group was all modified last by one person.

Answer 1

The "last saved by" name is also available to Windows:

.

I just haven't found a way to sort on it in Windows.

.

I found this PowerShell question that seems to contain the seed of an answer for you. But I don't know enough PowerShell to tweak it to work for Excel

.

https://groups.google.com/forum/#!topic/microsoft.public.windows.powershell/CGl6H9iTJL8

.

This free PowerShell script download:

https://gallery.technet.microsoft.com/scriptcenter/Get-Word-built-in-document-a688a1ce

also works on Word documents. But it should be tweakable to work on Excel.

.

You could also ask this question in the technet forum, referring to the 2 links above to get help adapting the tips in them to do what you want.

.

Answer 2

Thank you for the assistance!

Answer 3

GLCAL:

Did my reply help you find an answer? If not, you as the Original Poster have the option of removing the "Answer" flag that the moderator turned (inappropriately?) on .

Answer 4

Thank you for the quick feedback.  What I'm actually looking for is a way to sort by the name of the person shown in "Last Modified By" that can be seen in File/Info.  This is not an option in adding fields to Explorer such as Date Last Modified.  The name of the person who last modified the file is embedded in the Excel file, but so far I have not found a way to extract it for a mass sort.

Answer 5

In Excel, instead of using the useless open pane, go to the "old school" File open dialog, use the <CTL><O> shortcut.

In there you can see the Date modified column. You can click on it to sort by it.