Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I know how to modify file's creation date, but in Excel (xlsx) in file statistics/attributes/properties/whatever it still has the original creation date/last printed date etc. I was wondering if there is any way to modify this data.

share|improve this question
add comment

4 Answers 4

up vote 3 down vote accepted

I figured it out, and I guess it might be useful for some, so Ill answer my question myself. Note this works only for the new Excel file format (xlsx) or other new MS Office formats, ie office 2007 and newer. For older file formats do like Dennis Williamson suggested bellow.

Here are basic steps:

Open the Excel file using a zip utility such as 7zip Go to folder named 'docProps' Extract the file name 'core.xml' Open the file using a plain-text editor such as Notepad or Notepad++

You will see most(all?) file atributes inside angle bracket tags, such as

<dcterms:modified xsi:type="dcterms:W3CDTF">2010-10-03T15:59:33Z</dcterms:modified>

Modify the date or other info that goes BETWEEN the tags ie the date above. WARNING! don't modify the stuff INSIDE the tags (angle brackets) unless you know what are you doing.

Save the file when done. Go back into the zip utility and change the original 'core.xml' with the one you just edited. If using 7zip its as simple as drag and dropping it back and confirming overwrite. Go inside excel and confirm that all the information is modified. The end.

share|improve this answer
add comment

Using 7Zip as described above works well. Just be aware that time is stored as UTC (aka GMT) and you will need to adjust it to your time zone.

If for some reason you want to cover your tracks, editing the core.xml file will show that the file was modified on the date you made the modification. In that case, you should use Plan B, described in the next paragraph.

Saving to a new file won't work, at least not in Excel 2010; it carries the original creation date along with everything else into the new file. However, moving all of your worksheets to a new workbook gives you a clean start datewise...the date created will be the date you moved the worksheets.

share|improve this answer
add comment

The created dates, etc., are from the filesystem (I think the printed date is stored in the file) so any utility that can modify those dates for any file should be able to do it for your spreadsheet file. Here is an article that lists a few of those utilities.

share|improve this answer
    
Yep, I already modified those... but it seems the new excel format also has some of that data embedded. Although I modified the attributes in filesystem, when I go to file properties in excel it has all the original dates. If I had little more time I would research the file format and modify the embedded bytes by hand in hex editor or something, but I need this in next couple of hours sigh –  m0s Oct 4 '10 at 4:45
add comment

working with versions of excel including 2013

http://www.mrexcel.com/forum/excel-questions/79245-how-change-excels-file-original-creation-date.html

the 8th reply works!!!! :)

share|improve this answer
3  
Welcome to SuperUser! Please edit your answer to include the relevant details from the linked page in your answer. We try to avoid link-only answers here because they are only helpful as long as the linked page is available. –  Excellll Mar 5 at 19:21
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.