A corrupted Excel file is often the cause of crashes when using the Update Link feature.
In this article, you will talk about two different options to clean your Excel file:
If you have the Modeling Tools license you can use the Clean Function to remove all unused cell styles on the file and this will also remove the number formats.
Make sure that the Option "Remove all unused styles" is checked before applying the clean:
If you don't have access to the Modeling Tools, you can either delete each NumberFormat manually or use a tool called XLStylesTool created by Sergei Gundorov, available on the Microsoft Store.
Open the software, load your Excel File with the "Get File" button and then use "Process File" to start scanning the file.
The tool will first Scan your file, and then ask you if you want to start the Cleaning process:
Contact our Support team
If you still have issues with this error message after cleaning your file, or if you were unable to clean it, you can contact our Support team by using the "Signal an Issue to Support" function.
If you can provide the files, they will be able to clean them.