Automated Excel Workbooks and Task Scheduler

M

MSweetG222

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top