Default Excel and Word to only list XLS and DOC files

R

ray

How do i setup Excel and Word to default view only .xls
and .doc files within a selected folder.Currently the
setup displays all excel and word files e.g xls ; xla
 
F

fuzzyfreak

Usually, you select Open, change the Files of type to the one you wan
(*.doc or *.xls) and click cancel. It should remember your settin
next time. I have got it to work for Word but not Excel for som
reason. Try this first and let me know how you get on
 
D

Dave Peterson

You could add one extra step.

Type in:
*.xls
and hit enter
in that file|open|File Name box
(*.doc for Word)

And if I want to limit it more, I'll even include a partial name:

*invoice*.xls

I'll only see the workbook file names that contain invoice.
 
Top