To understand....do this from Excel 2007....
1) Use Windows Explorer and find a directory on your computer that has files
in it of different file types....like Excel.xls and Word.doc and Powpoint.ppt
2) Then, open Excel 2007 ....start a new document.
3) On the Upper left, select the Office Button and select the "SAVE AS"
Option.
4) In the "SAVE AS" window, locate the directory you found in step 1 above.
5) When you locate the directory, select the file type that you want to use
to save your new file. For the sake of argument, save it as an Excel file
(any version).
6) When you do, note that the only files in that directory that you see in
the "Save As" window are the ones that are of the same file type as the one
you're saving. Note that you can't see any of the other ".doc" or ".ppt"
files in the window.
THAT'S THE PROBLEM. In prior versions of Office, all of the files in the
directory could be seen from the "SAVE AS" window....regardless of file type.
This was very handy because when saving a new file, you could use the "SAVE
AS" window to search all your directories and put the file in the same folder
as others even if they were of a different type.
If on your system you can see of all file types in the "SAVE AS" window,
then that gives me hope that there is a setting that will allow mine to
function that way.
Let me know what you find.