Long python process apparently timing out

Open peoplebuilder opened this issue 11 years ago • 2 comments

I have a long-running python process that works independently and works properly in Excel when runtime is under 90 seconds or so. If the runtime is sufficiently long, Excel generates an alert - "Microsoft Excel is waiting for a another application to complete an OLE action".

This is pretty clearly a timeout, but I can't figure out how to set a longer timeout - maybe 600 seconds. Is it possible to set a longer timeout for ExcelPython

Jan 29 '15 01:01 peoplebuilder

Hi,

this behaviour is typical of VBA calling external programs that are slow.

It happens with Oracle, Matlab, Datastream... But it does not mean the process stopped.

Oct 16 '15 20:10 AntonioSuriano

Thanks Antonio, actually I think I forgot to reply to this issue.

What Antonio says is entirely correct, unfortunately though I do not know of a way of increasing the timeout.

Oct 19 '15 13:10 ericremoreynolds