I am trying to import a table from Excel (Version 14.0.6129.5000 (32 bit) part of Office Professional 2010) into ID CC.
Using File/Place and ticking the "Show Import Options" box opens a dialogue box but the drop-down menu showing individual sheets within the dcoument only shows the first sheet, so that i cannot access the sheet that I want.
Copy these sheets to a new document and save it again.
Try to save as to older verison: Excel 97-2003 Workbook.
Saving as older version didn't work. Saving the individual sheet as a separate document has worked, but is a clumsy solution as I want to be able to update the document on a regular basis.
Try using a named range.