Microsoft Excel Hints and Tips
Question
How do I find out the name of the last user who opened an Excel file ?
Solution
When you open an Excel file, your name is embedded in the file. This occurs even
if you do not save the file.
Note - This behaviour does not occur if the file is a read-only file, or if personal information has been removed. To remove personal information from an Excel workbook select Tools > Options > Security and then check Remove personal information from file properties on save.
The name that is stored is the user name listed in the Options dialog box - Tools > Options > General.
To see the name simply open the Excel file using any text editor such as Notepad or Microsoft Word. The users name will appear somewhere within the text.
Return to Excel Exchange homepage.