PC Review


Reply
Thread Tools Rate Thread

Automated Excel Workbooks and Task Scheduler

 
 
MSweetG222
Guest
Posts: n/a
 
      28th Apr 2008
Hello all,

I have several automated Excel workbooks running in task scheduler (they
kick off every 5 minutes). Everything was working just fine until 4/23/2008
between 12:00am & 1:00am. After that, my Excel workbooks become hung in Task
Manager (i.e. after the macro runs and the Excel workbook appears to be
closed, the Excel process shows as still running in Task Mgr). Additionally,
these hung Excel processes eat up alot of memory & cpu (it pegs the cpu usage
at 100%) and drags the entire speed of my computer down to nothing.

I have been running these programs for about 2 years. I think there must
have been a windows update or a norton virus scan update that effected task
scheduler. I don't have any issues if I open the Excel workbook by hand
(program runs and once the workbook closes, the Excel process disappears from
Task Mgr).

Does anyone have any suggestions on how to go about figuring out what to do?

Thank you for your help.

MSweetG222
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: task scheduler does not reconize excel NickHK Microsoft Excel Programming 0 8th Dec 2006 02:31 AM
Use Task Scheduler to automatically run Excel workbook =?Utf-8?B?Sm9obiBIYXplbA==?= Microsoft Excel Programming 0 22nd May 2006 02:06 PM
Excute a Excel worksheet with Task Scheduler Randy Microsoft Excel Programming 0 8th Sep 2004 01:53 PM
Re: Excel; How to Create Automated Master List from 4 Workbooks? Frank Kabel Microsoft Excel Misc 0 30th Jul 2004 04:10 PM
Defrag and Disk Cleanup Utils automated in Task Scheduler =?Utf-8?B?SmFzb24gQmVubmV0dA==?= Windows XP Performance 2 14th Jan 2004 05:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:25 AM.