I have linked and placed an Excel table in Indesign. All works well except of the cells, where text is referred from different Sheet of a same Excel file (smth like this =Sheet2!B2 ), then the cell stays empty. At the same time, if I refer to the number using the same reference, then it works well. I have tried all possible Cell Formats, but no results.
Does anyone know the way to import Excel table with text references so the latter will be displayed in Indesign?
Thank you in advance,
Is your Excel saved as xlsx? Try xls.
Thank you, Pickory!
Re-saving as .xls format solved this issue.