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
LVL 4
Stephen KairysTechnical Writer - ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lawrence BarnesCommented:
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
0
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
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
0
Lawrence BarnesCommented:
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.
0
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

Stephen KairysTechnical Writer - ConsultantAuthor Commented:
OK, I checked this out and the workbook is not shared. So are you saying this bug would still apply then?
Thanks.
0
Lawrence BarnesCommented:
Yes, and as far as I can see the bug has not been fixed.  If the file is less than 64,000 rows try saving the file as an Excel 2003 document and see if the problem continues.  Then you'll know.  The only other thing to consider (and I wouldn't) would be to remove the security update that caused the bug in the first place.  Hate to mention it but there is also the option of upgrading.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thank you. Saved as XLS (97-2003) format and the timestamp is now being updated.
I Appreciate the help!
-Steve
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.