Why is date accessed and date modified different?(Excel 2000)

  • Thread starter Thread starter Puzzled
  • Start date Start date
P

Puzzled

Hi,

I am puzzled by the fact that one of my excel documents shows a different
modified time than the the accessed time. I do not remember saving(i wrote
down the last time I saved and the time modified) and this time is changed. I
don't share computers with anyone. Does the system modify these files
sometimes?

Thanks,
Ed
 
Some functions such as NOW and TODAY are "volatile" meaning that they will
cause a calculation of those cells when any calculation is mode, including
updating those values when the workbook is open.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
When you open a workbook the modified date changes to current.

If you close the workbook with no changes or save, the modified date will
revert to last modified date which is last saved date.

Open Windows Explorer and find a workbook saved before today and note the
modified date,

Now open that workbook and View>Refresh in Windows Explorer.

Date will change to current.

Close the workbook without save and View>Refresh in WE.

Note date changes back to original.


Gord Dibben MS Excel MVP
 
Back
Top