Error converting when linking Excel data with a formula returning a blank cell (i.e. "")
InDesign Version: 17.4 x64
When importing data from an Excel document, an error message is received on InDesign whenever the data includes a formula which returns a blank cell (i.e. using IF formula and returning "").
Expected result: All data from range is imported, regardless of whether cells are blank or not.
Actual result: Error message reading: "Cannot convert document. An unknown error occurred during the conversion."
Unable to upload jpeg or GIF (not supported, apparently)!
2
votes
Will
shared this idea