Quite often, after a report is run an Excel process (sometimes more than one) is still running even if Excel is not open.
I run several reports a day automatically using the Task Scheduler and when this happens, future reports fail until I manually close out those Excel processes.
Any suggestions how to fix this?
Do you have the parameter "Close Book After Completion" checked in the Reports Properties tab?
I am having same issue. "Close Book on Completion" is checked, however, each time the report is run either manually or through Task Scheduler, an instance of Excel is left open. Any help is appreciated.