Constantly getting #Connect! in one workbook with Python, others work fine. O365 subscriber

microsoft / python-in-excel

Python in Microsoft Excel

MIT License

523 stars 36 forks source link

Constantly getting #Connect! in one workbook with Python, others work fine. O365 subscriber #61

Open santiago-afonso opened 1 month ago

santiago-afonso commented 1 month ago

Hello. I'm constantly getting #Connect! error in =PY cells, without the green 'busy' icon. If I perform a Reset Runtime, then it runs, for a couple of times, until the error comes back. Other workbooks work fine. While it works, the problematic workbook is constantly refreshing the data, despite there being no volatile formulas or circular references (as far as I can tell). This makes it impossible to work. Can provide the workbook for analysis.

Thanks.

salabim commented 1 month ago

Switch to AnacondaCode, which doesn't require to upload to the cloud. So much better ...

santiago-afonso commented 1 month ago

If it weren't for customer requirements, sure...

keyur32 commented 2 weeks ago

Hi @santiago-afonso, sorry for the delay. Can you please share a session id for that workbook so we can investigate? You can capture it via File > Account > About Excel > Session ID.

Also what is the error subtype you see for #CONNECT!. If you click on the yellow triangle to the right of the cell, it will give you a description of the error.

Thanks