When I first open Excel 2002 and want then to open an existing file I press the 'Open' icon. I then have to wait for about 40 seconds for it to populate the list of available files - about 5700. If on the other I instead press the 'SaveAs' icon the file dialogue appears and lists the files in about 6 seconds. I can then close the SaveAs dialogue box, press the 'Open' icon and the list of files is available in 1 second - so speeding up the whole process.
If I then close Excel and re-open it, press the Open icon, the files are listed in 1 second. That holds true for the rest of the day.
So my question is why is one way faster than another? What is happening and why does it behave that way?
Clearly this question is just for interest and is not crucial for anything other than to satisfy my curiosity.