Configure Windows to Run Excel in "non-interactive mode"
How to configure Windows to allow Excel to run in "non-interactive mode". "non-interactive mode" may be required to run Excel from a scheduler.
Microsoft informs me that my issue is with running Excel in "non-interactive mode", you require two directories to be created.
You have to create a folder (or two on a 64bit-windows):
(32Bit, always) C:\Windows\System32\config\systemprofile\Desktop(64Bit) C:\Windows\SysWOW64\config\systemprofile\Desktop
The MS Excel when you are trying to run in non-interactive mode will look for this, if it is not present it will not open in the non-interactive mode.
once these were created the scheduled task runs flawlessly.