asked on

EXCEL 2007 - timestamp on XLSX flie does not get updated

Hello,
I have a spreadsheet in EXCEL 2007 which I modify every morning. Since 9/18/13, the timestamp is not getting updated even though I modify some cells. The file is located on a local drive on an XP machine.

Does anyone know what would cause this issue and how to fix it?
Thanks,
Steve

Lawrence Barnes

This appears to be a but with Excel 2007 that occurred after a security update. You cand find more information here:
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/08/10/quot-date-modified-quot-time-stamps-on-shared-excel-files-stored-on-a-network-drive-will-not-update-correctly-after-saving-and-closing-the-file.aspx

If you do not have over 64,000 records you could save the file as Excel 2003, which purportedly does not have this bug.

LVBarnes

Stephen Kairys

ASKER

That's interesting, thank you.
That said, this is on a LOCAL drive (although it's really a SUBST'd drive, I wonder if that is included in the bug.)
I don't recall if I made this a shared workbook, how would I check for this in 2007?
Thanks
Steve

Lawrence Barnes

I think that the bug includes local drives and that the sharing on the link was just their way of showing the date rolling back.

Here's a link to 2007 workbook sharing:
https://askdrexel.drexel.edu/app/answers/detail/a_id/2548/~/how-to%3A-share-a-workbook-in-excel-2007.

Stephen Kairys

ASKER

OK, I checked this out and the workbook is not shared. So are you saying this bug would still apply then?
Thanks.

ASKER CERTIFIED SOLUTION

Lawrence Barnes

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Stephen Kairys

ASKER

Thank you. Saved as XLS (97-2003) format and the timestamp is now being updated.
I Appreciate the help!
-Steve