Searching for workbooks when running Excel 2010 on Windows XP
Unfortunately, if you use Windows XP, the Open dialog box in Excel 2010 doesn't have a search feature built into it. This means that to search for missing workbooks, you have to do it outside of Excel by using Windows XP's search feature.
To use the Windows XP Search feature to find a workbook, follow these steps:
- Click the Start button on the Windows XP taskbar and then click Search in the right column of the Start menu.
Windows opens a Search Results dialog box.
- Click the Documents link in the left panel of the Search Results dialog box.
- Click the All or Part of the Document Name text box and then type the filename or the part of the name that you're sure of.
You can type an asterisk (*) for multiple missing characters and a question mark (?) for single missing characters that you can't supply in the workbook filename to help narrow your search.
- Click the Search button to have Windows XP begin searching for the workbook file.
Windows displays all the workbook files that match your search criteria in the list box on the right side of the Search Results dialog box.
- When you locate the workbook file you want to open in Excel, double-click the filename