Searching for Files in the Open Dialog Box
The Basic File Search and Advanced File Search task panes aren't the only places from which you can do searches for the workbooks that you need to open. You can also perform a basic or advanced search from within the Open dialog box itself. To access the Search feature, click the Tools button on the Open dialog box's toolbar and then select the Search item.
Like the File Search task pane, the File Search dialog box enables you to choose between performing a basic or more detailed search with its Basic and Advanced tabs. Each tab contains the same search options as the Basic File Search and Advanced File Search task panes, so searching for files in the File Search dialog box is just like doing a search from those two task panes.