You have to go into Tools, Find and change the Property drop down to "Last
Modified".

--
Jim
"WomensHealthUSA" wrote in
message ...
| In Microsoft Excel 97 there is a option where I can open a file that is
last
| modified in a week, month or even today but this option does not appear in
| Excel 2000. Does anyone know how I turn that on????
|