Excel Labs fails to load and save complex modules in AFE, showing error code: 0x8007000E

[davidvontamar]

Excel Labs fails to load and save in AFE with error code: 0x8007000E. I'm afraid it is related to the complexity of my functions. There are over a dozen of them, reaching together 800 lines of Excel formula code. These are lengthy lambdas with quite a few variables and complex logic in them.

It did not happen while I used named functions and named expressions within Excel Labs (but sometimes, certain expressions would cause this error too upon saving). However, after moving all of the code to the AFE for maintenance reasons, Excel Labs suddenly refused to load or save the modules, returning error code 0x8007000E.

[NWilson]

I'm sorry to hear that, it's painful.

I have a ticket in the backlog to try and improve on this experience. When there is a save error, the Excel taskpane API does not currently give a clear indication of where the problem is. We bulk-save the contents of the modules, so if there's a syntax error in even one of the lambdas, we can't pinpoint from the API which one specifically failed.

One very painful way to resolve this is to copy the contents out of the module (into notepad); save; then copy in half the functions; save; and so on, to narrow down which one is being rejected.

This is on the assumption that one of the functions likely has a minor error which is causing Excel to reject it.

[NWilson]

Thank you for those suggestions.