Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slow-Opening Excel Application
Pertaining to an Excel 2000 VBA application: Sometimes the
performance slows and the application opens very slowly or won't open at all. I learned that, in Windows 98, I could delete all .tmp and .emf files from the Windows Temp directory (there would sometimes be over 1,000 in this folder) and performance would be restored. Now, I'm having the same performance-slowing in Windows XP Professional. Thinking I would be able to use the same fix (clearing the Windows Temp folder), I was surprised to find no .tmp or .emf files in there. I did a search for these suspected culprits, but there don't seem to be significant numbers of them anywhere on the machine. What could be going on here? What are the possible causes and fixes for this degraded performance. The application file takes about five minutes to open under XP Professional. I'm afraid to close it for fear it won't open again. Help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slow-Opening Excel Application
In Windows XP the TEMP files are stored in the users profile.
Depending on certain settings in explorer you cannot find these files as they will be hidden. The Directory name will be similar to: NOTE you've gotta change it to YOUR username. "C:\Documents and Settings\JoeTheMan\Local Settings\Temp" If you cant browse to it.. IN Explorer: Tools/Folder Options View Tab SELECT Show hidden Files and Folders DESELECT Hide Protected Operating System Files Not sure that this one is needed. :) Then browse to above folder and ADD it to your favourites. keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Joe Conti" wrote: Pertaining to an Excel 2000 VBA application: Sometimes the performance slows and the application opens very slowly or won't open at all. I learned that, in Windows 98, I could delete all .tmp and .emf files from the Windows Temp directory (there would sometimes be over 1,000 in this folder) and performance would be restored. Now, I'm having the same performance-slowing in Windows XP Professional. Thinking I would be able to use the same fix (clearing the Windows Temp folder), I was surprised to find no .tmp or .emf files in there. I did a search for these suspected culprits, but there don't seem to be significant numbers of them anywhere on the machine. What could be going on here? What are the possible causes and fixes for this degraded performance. The application file takes about five minutes to open under XP Professional. I'm afraid to close it for fear it won't open again. Help! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slow-Opening Excel Application
Also... check the size of your excel.xlb file. On my Win98SE system this is
at C:\WIN98\Application Data\Microsoft\Excel, but on XP it might be somewhere else. This file holds menu bar & toolbar customisations. If it's huge (mine's 9kb, which is about normal size) then just delete it (after you've closed xl) and restart xl, whereupon it will be recreated by default. Unfortunately, doing this will lose any menu/toolbar customisations that you may have carried out and re-instate the defaults. "Joe Conti" wrote in message ... Pertaining to an Excel 2000 VBA application: Sometimes the performance slows and the application opens very slowly or won't open at all. I learned that, in Windows 98, I could delete all .tmp and .emf files from the Windows Temp directory (there would sometimes be over 1,000 in this folder) and performance would be restored. Now, I'm having the same performance-slowing in Windows XP Professional. Thinking I would be able to use the same fix (clearing the Windows Temp folder), I was surprised to find no .tmp or .emf files in there. I did a search for these suspected culprits, but there don't seem to be significant numbers of them anywhere on the machine. What could be going on here? What are the possible causes and fixes for this degraded performance. The application file takes about five minutes to open under XP Professional. I'm afraid to close it for fear it won't open again. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel opening from other application | Excel Discussion (Misc queries) | |||
Opening Excel 2007 application | Excel Discussion (Misc queries) | |||
My file is not opening within my excel application? | Excel Discussion (Misc queries) | |||
Excel opening but file does not open with Application | Excel Discussion (Misc queries) | |||
Opening Excel Application difficulty | Excel Discussion (Misc queries) |