How do I change the default view (to "details", ordered by date modified,
most recent date at the top) in Excel 2000?

Thank you!

Record a macro when you do data|filter|showall (to show the details).
Then continue recording when you sort your data the way you want.

Now name that macro
Sub Auto_Open()

It'll run each time you open the workbook (well, with macros enabled that is).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

(Ps. Is that what you meant by details?)

hello wrote:

How do I change the default view (to "details", ordered by date modified,
most recent date at the top) in Excel 2000?

Thank you!

--

Dave Peterson