How to programmatically handle the warning "This workbook contains one or more links that cannot be updated"

I’m dumping an output xls file (C#) which has few columns. One of the column has XML input file names as values. The input files names are of like this: 100@test1.com.xml,1010@test2.com.xml etc. When I try opening the output file this warning pops up

“This workbook contains one or more links that cannot be updated”.

If I copy that whole column and paste it again this warning is removed. I want to handle this warning in the code itself. What change I should do in the code while dumping files names so that this warning is removed?


Source: .net

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.