In Excel 2002 (Windows XP Pro OS), is there a way to have the Import External
Data path default to the last folder visited (the way it did in Excel 97),
rather than going to "My Data Sources" each time? All my text data files are
organized deep under several layers of folders withing my general "Data"
folder, and as it stands now, I need to navigate through the same set of
multiple folders every time I want to import four or five seperate data files
which all reside in the same folder.