Excel 2003 is extremely slow to open the Save As dialog box when saving from a website.
Clean install Windows XP SP3
Not on Domain
No mapped (network) drives
Internet Explorer 7
Connect to hosted PeopleSoft application over the Internet (HTTPS)
Run PeopleSoft report to Excel format, Open the file in Excel, directly from PeopleSoft and then select Save As to save a copy to your computer (local C: drive):
Excel 2000 – Save As dialog box comes up in under 2 second
Excel 2010 - Save As dialog box comes up in under 2 second
Excel 2003 – Save As dialog box takes about 30 seconds to open
With report still open in Excel, unplug the network connection, go to File -> Save As and Excel 2003 opens the Save As dialog box in about 2 seconds.
It appears Excel 2003 has to check back in with the web server, if available, before it will open the Save As dialog box.