python code exported on save?

[ekwf]

We have a set of shared directories on dropbox for a group of analysts. Some of these directories are editable and some are viewable, but not editable. We have xloil-python code saved in one of the viewable directories and several models in excel that use this code saved elsewhere in editable folders.

Recently several users reported that their models fail to load xloil (despite it working fine the prior day). I noticed that there was a pycache folder and a python file (dated from 2023 and named the same as the model sheet) saved in the folder. Users are not explicitly creating this and the symptom is that they can't initialize the model. There is also nothing in our python code that would do something like that.

Deleting the py file, pychache folder, removing the xloil vba module and re-opening seems to fix the issue and loads xloil from the right location. Understandably this is very annoying for the user.

Is there anything in xloil that would lead to this kind of thing? I can't seem to find anything like this in the documentation. It's also very strange that the py file has a date so far back in the past, but is named the same as the latest name of the model sheet file.