They may also be created by software installation programs.Too many temporary files can cause problems, so clean them out from time to time, but be careful not to do this if you are have done a software install that requires you to reboot your PC, but have not yet done so.Excel 2002 (Office XP) can make effective use of more RAM than previous versions.
This may also cause problems opening/saving a workbook on a WAN (or even a LAN).
These temporary files may also build up in your windows temporary directory: - Try deleteing all files and subfolders in Windows\Temp or documents and settings\\local settings\temp If possible open the workbook(s) you are linking to before the workbook that links.
To turn Journalling off try one of these (depends on your version of Outlook): Find Fast/Fast Search has a disconcerting habit of springing to life whenever you dont need it, and in my opinion it doesnt do anything very useful anyway besides chew up a lot of hard disk space.
My advice is to turn it off: Make sure your Windows swap file is located on a disk with a lot of space, and that you de-fragment the disk from time to time.
Excel 2002/2003 has advanced encryption methods which may slow open and close for protected workbooks.
New Excel 2002/2003 features such as Fast Search and Background Error Checking may also slow response time.
I tend to use a lot of add-ins, and if I don't check from time to time the number of add-ins automatically loaded can get large.
Periodically prune the list of add-ins that are automatically loaded (Tools--Addins), or check out my Auto-Reversioning Demand-Loading Addin Loader.
Delete the excess rows and columns, or use Fast Excel V2's Clean Workbook command.