1 person found this helpful
It's a bug and Adobe is aware of it. The only workaround is to save back to XLS format.
I've tested the workaround and I've found it to work. I'm not sure why you're not seeing the named ranges when doing so.
Edit: I just noticed that you're using CS4. I've only tested this with CS5 and CS5.5.
I retested it again. It seems like CS4 cannot read the named range which has different columns (or cells possibly), i.e named range saved with columns A and C. If only column A is saved or X... n (e.g. A,B,C...) is saved in a sequence, it works fine. Maybe it has to do with there is no value. See attached file.
How do I get around it? I don't think it is possible for any indesign to read different columns/cells. It would be the same as reading from different cells. How would indesign place the object if it did...
Prove me wrong anybody...
Excel (AC has no value)
Indesign (AC is not displayed)
I dug up this topic because I'm experiencing the same issue in Indesign CC 2017.
Does InDesign really not support XLSX for importing this way? Only the older standard XLS (pre 2013) ?
Is there any sight on whether this will be fixed at all?