Please, suggest me on the issue I cannot resolve for a long time.
I have an Excel Template that should be filled in with data from a Sales Invoice. One sheet of the Template contains information about Service Lines of the Invoice, another one - about Salaries. If an Invoice doesn't contain either type of lines, the corresponding sheet should be removed. When saving the file after filling it and opening it from a local storage, Excel notifies that the file is corrupted and asks if I trust the resource which provided the file.
The problem is that this file potentially should go to Customer and it is not acceptable if a person opens it and sees such a suspicious message.
How can the 'repair works' be conducted on the Navision side before the file is sent.