| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Temp files causing performance degradation
We're having problems with our users getting too many temp files building up in thier temp directories. We're on Win98 and WinXP, the problem is worse on 98, but still happening on XP. Our support people are helping our users clean up their temp files to regainthe performance, but I'd like to know if there's anything any one knows that will stop this proliferation of temp files by Excel. The files that seems to be primary culprits (these are variations on a single master file) have from 20 to 40 sheets with about 8 buttons on every other sheet. There is one UDF being used. The files all point to a common VBA file for the code execution. Any ideas on what would be the cause of all of the temp files or a method to manage their growth outside of cleaning out the temp directory every two weeks? -- FrankB ------------------------------------------------------------------------ FrankB's Profile: http://www.excelforum.com/member.php...o&userid=18952 View this thread: http://www.excelforum.com/showthread...hreadid=480679 |
|
#2
|
|||
|
|||
|
Temp files causing performance degradation
I would guess that excel only builds temp files that it needs--so I'm gonna
guess you're not going to be able to do anything that will change excel's behavior (and still keep excel useable, that is). But... Personally, I'd put a VBS script on a network drive and put shortcuts to that VBS script on everyone's desktop. This VBS script would clean the Temp folder (much easier than doing it manually). This is the one I use. It was written by Michael Harris: http://groups.google.com/groups?thre...%40tkmsftngp02 Since there are lots of programs that write to the temp folder (and don't clean up after themselves), I like the .vbs approach. I just click on that shortcut after I close everything and am shutting down the pc--or when I start it up--before I load any application. ======== Ps. I'm betting that those buttons on the worksheet are from the control toolbox toolbar. Maybe you could replace them with buttons from the Forms toolbar (you'll probably have to modify some code, too). (I'd just click the shortcut to the .vbs file, though.) FrankB wrote: We're having problems with our users getting too many temp files building up in thier temp directories. We're on Win98 and WinXP, the problem is worse on 98, but still happening on XP. Our support people are helping our users clean up their temp files to regainthe performance, but I'd like to know if there's anything any one knows that will stop this proliferation of temp files by Excel. The files that seems to be primary culprits (these are variations on a single master file) have from 20 to 40 sheets with about 8 buttons on every other sheet. There is one UDF being used. The files all point to a common VBA file for the code execution. Any ideas on what would be the cause of all of the temp files or a method to manage their growth outside of cleaning out the temp directory every two weeks? -- FrankB ------------------------------------------------------------------------ FrankB's Profile: http://www.excelforum.com/member.php...o&userid=18952 View this thread: http://www.excelforum.com/showthread...hreadid=480679 -- Dave Peterson |
|
#3
|
|||
|
|||
|
Temp files causing performance degradation
AFAIK you wont get any fewer temp files with Forms controls unless you have
fewer controls. But since i find it hard to imagine a sensible menu with 160 different commands I would assume that a lot of the buttons are basically the same but maybe need to know what sheet is active: so my advice would be to convert all the code to an XLA with its own menu and/or toolbar and/or formas and you probably only have 10-30 items on the menu. regards Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "Dave Peterson" wrote in message ... I would guess that excel only builds temp files that it needs--so I'm gonna guess you're not going to be able to do anything that will change excel's behavior (and still keep excel useable, that is). But... Personally, I'd put a VBS script on a network drive and put shortcuts to that VBS script on everyone's desktop. This VBS script would clean the Temp folder (much easier than doing it manually). This is the one I use. It was written by Michael Harris: http://groups.google.com/groups?thre...%40tkmsftngp02 Since there are lots of programs that write to the temp folder (and don't clean up after themselves), I like the .vbs approach. I just click on that shortcut after I close everything and am shutting down the pc--or when I start it up--before I load any application. ======== Ps. I'm betting that those buttons on the worksheet are from the control toolbox toolbar. Maybe you could replace them with buttons from the Forms toolbar (you'll probably have to modify some code, too). (I'd just click the shortcut to the .vbs file, though.) FrankB wrote: We're having problems with our users getting too many temp files building up in thier temp directories. We're on Win98 and WinXP, the problem is worse on 98, but still happening on XP. Our support people are helping our users clean up their temp files to regainthe performance, but I'd like to know if there's anything any one knows that will stop this proliferation of temp files by Excel. The files that seems to be primary culprits (these are variations on a single master file) have from 20 to 40 sheets with about 8 buttons on every other sheet. There is one UDF being used. The files all point to a common VBA file for the code execution. Any ideas on what would be the cause of all of the temp files or a method to manage their growth outside of cleaning out the temp directory every two weeks? -- FrankB ------------------------------------------------------------------------ FrankB's Profile: http://www.excelforum.com/member.php...o&userid=18952 View this thread: http://www.excelforum.com/showthread...hreadid=480679 -- Dave Peterson |
|
#4
|
|||
|
|||
|
Temp files causing performance degradation
Charles Williams Wrote:[color=blue] AFAIK you wont get any fewer temp files with Forms controls unless you have fewer controls. But since i find it hard to imagine a sensible menu with 160 different commands I would assume that a lot of the buttons are basically the same but maybe need to know what sheet is active: so my advice would be to convert all the code to an XLA with its own menu and/or toolbar and/or formas and you probably only have 10-30 items on the menu. regards Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "Dave Peterson" wrote in message ... That's where I started, but I couldn't come up with a way to differentiate between the three different types of sheets the file requires with 100% confidence. My compromise was to put only the controls needed for each type of sheet on the appropriate sheet. Right now, the problem is that copies of this file have proliferated out to almost a dozen users with 1-10 copies per user, so trying to pull them all in and modify them is out of the question (I'd rather have one of our support people write a cleanup script and run it on a scheduled basis). -- FrankB ------------------------------------------------------------------------ FrankB's Profile: http://www.excelforum.com/member.php...o&userid=18952 View this thread: http://www.excelforum.com/showthread...hreadid=480679 |
|
#5
|
|||
|
|||
|
Temp files causing performance degradation
A bad memory on my part.
I thought that the controls from the control toolbox toolbar caused more of those tmp files to be created. But a simple test disproved that. Although, I did get one extra subfolder (called Excel8.0) with a few controls from the control toolbox toolbar (not very significant, huh?). Thanks for the correction. Charles Williams wrote: AFAIK you wont get any fewer temp files with Forms controls unless you have fewer controls. But since i find it hard to imagine a sensible menu with 160 different commands I would assume that a lot of the buttons are basically the same but maybe need to know what sheet is active: so my advice would be to convert all the code to an XLA with its own menu and/or toolbar and/or formas and you probably only have 10-30 items on the menu. regards Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "Dave Peterson" wrote in message ... I would guess that excel only builds temp files that it needs--so I'm gonna guess you're not going to be able to do anything that will change excel's behavior (and still keep excel useable, that is). But... Personally, I'd put a VBS script on a network drive and put shortcuts to that VBS script on everyone's desktop. This VBS script would clean the Temp folder (much easier than doing it manually). This is the one I use. It was written by Michael Harris: http://groups.google.com/groups?thre...%40tkmsftngp02 Since there are lots of programs that write to the temp folder (and don't clean up after themselves), I like the .vbs approach. I just click on that shortcut after I close everything and am shutting down the pc--or when I start it up--before I load any application. ======== Ps. I'm betting that those buttons on the worksheet are from the control toolbox toolbar. Maybe you could replace them with buttons from the Forms toolbar (you'll probably have to modify some code, too). (I'd just click the shortcut to the .vbs file, though.) FrankB wrote: We're having problems with our users getting too many temp files building up in thier temp directories. We're on Win98 and WinXP, the problem is worse on 98, but still happening on XP. Our support people are helping our users clean up their temp files to regainthe performance, but I'd like to know if there's anything any one knows that will stop this proliferation of temp files by Excel. The files that seems to be primary culprits (these are variations on a single master file) have from 20 to 40 sheets with about 8 buttons on every other sheet. There is one UDF being used. The files all point to a common VBA file for the code execution. Any ideas on what would be the cause of all of the temp files or a method to manage their growth outside of cleaning out the temp directory every two weeks? -- FrankB ------------------------------------------------------------------------ FrankB's Profile: http://www.excelforum.com/member.php...o&userid=18952 View this thread: http://www.excelforum.com/showthread...hreadid=480679 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Temp files in Excel | Excel Discussion (Misc queries) | |||
| Recently Used File List - 2002 Contains 'Temp' Files | Excel Discussion (Misc queries) | |||
| delete all the contents (sub folders and files) in the temp folder | Excel Discussion (Misc queries) | |||
| Excel creating temp files upon save. | Setting up and Configuration of Excel | |||
| Location of Temp File(s) - If any | Excel Discussion (Misc queries) | |||
Hybrid Mode
