Missing entries when a cell contains an error (external referrence)

[B0ndo2]

I have an XLSX file where some of the cells shows an error because it is linked to an external file and was not updated. The resulting csv file then has missing values from the cell before it and till the end of the row