Good day!
Welcome to Microsoft Community. Thank you for sharing your concern with us today and we hope that all is well. This unusual behavior can happen when Explorer’s “recent files” list depends on metadata that isn’t being updated as you expect. In your case, the persistent date (6 July 2024) may not be one of the standard fields (like Date Modified) but rather a custom or cached property stored inside the Excel file. Here are some steps to diagnose and work around the issue:
Inspect the File’s Properties Thoroughly
- View All Details: Right-click the Excel file and select Properties, then go to the Details tab. Look for not only Date Modified and Date Created but also any other fields such as “Last Printed” or custom properties.
- Open Advanced Properties in Excel: In Excel, click File > Info, then click on Properties (usually at the top right) and choose Advanced Properties. Under the Summary and Custom tabs, see if there’s a date field set to 6 July 2024 that might be overriding the file’s apparent “recent” date.
Refresh the Indexing and Recent Items Cache
- Clear File Explorer History: Open File Explorer Options (via the Control Panel or by searching in Start), and click Clear under “Privacy” to clear the recent files history. Then reopen the file and see if a new date is recorded.
- Rebuild the Windows Search Index: Open the Indexing Options control panel, click on Advanced, and then choose Rebuild. This forces Windows to re-read file metadata.
Try Saving a New Copy of the File
Sometimes legacy or hidden metadata can “stick” in one file. To test this:
- Open your Excel document.
- Save As a new file (preferably with a different name and in a different location).
- Update the new file and check whether it now shows the current date in its recent list. If the new file behaves normally, then the original document likely has an embedded or corrupted metadata field that isn’t updating.
Check for Macros or Add-ins
- Disable Macros/Add-ins: If the file has any macros or is using custom add-ins, they could be inadvertently setting or preserving a date value.
- Remove or Disable Them: Temporarily remove or disable these features, then update and close the file to see if Explorer picks up the correct date upon your next update.
Hope this helps!
Fritz-Bald
Microsoft Community
Moderator