Import XLSX spreadsheet to an InDesign table: the "-1" problem
There is a bug by adding linked xlsx-files to InDesign when the cell in Excel contains a formula which returns text. There is no issue with numbers.
InDesign Vers. 15.1.1 / Windows 10
I have the same problem. Some work on this would be appreciated. It is completely unreasonable for us to tell our users that they have to continue using the old file type of .xls instead of creating new upgraded .xlsx files.