Problem with UDF in Excel Add-in

Add-in Express™ Support Service
That's what is more important than anything else

Problem with UDF in Excel Add-in
 
Marcel Mrozinski




Posts: 13
 Joined: 2019-10-28
Hi there,

we have an Add-in (combination of COM-Add-In AND XLL with one UDF), this worked fine for years. All of a sudden we have the following problem: In a workbook (XLSX) the UDF is used and works fine. Then the file is saved (into Documents). When opening the file the next time, Excel shows a error message:

We found a problem with some content in "filename.xlsx" Do you want us to try to recover as much as we can?


If we click on ?Â?Ð?èYes?Â?Ð?é, we get a dialog and a logfile stating that records are deleted: 

<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName> error051360_01.xml</logFileName><summary>Error in file 'C:Users	estDocumentsilename.xlsx'</summary> <additionalInfo><info>Excel has completed checking and repairing at the file level. Some parts of this workbook have been repaired or discarded.</info></additionalInfo><removedRecords><removedRecord>Removed records: Formula from /xl/worksheets/sheet1.xml-Part</removedRecord><removedRecord>Removed records: Formula from /xl/calcChain.xml-Part (calculation properties)</removedRecord></removedRecords></recoveryLog>


In the result, the UDF is deleted and the cells are containing the last results they had when saving the file. Do you have any idea, whats causing this problem and how to solve it?

With best regards,
Marcel Mrozinski
Posted 10 Nov, 2021 05:48:49 Top
Andrei Smolin


Add-in Express team


Posts: 19122
 Joined: 2006-05-11
Hello Marcel,

We haven't got such reports but googling suggests that the issue may relate either to your code or to the workbook you are using. Are you able to reproduce the issue with a new workbook? Can you send a workbook and code for me to reproduce the issue on my side?

Regards from Poland (CEST),

Andrei Smolin
Add-in Express Team Leader
Posted 10 Nov, 2021 08:17:28 Top