Have you tried .xlsx?
Named ranges don't work with XLSX files due a long standing bug.
I haven't used this workflow for quite some time but if I have a chance I'll see if I can reproduce this.
Does this problem happen if you place the same files in CS4?
Thank you, Bob.
I was aware of the .xlsx issue, which is why we have been saving the files back to .xls.
This problem wasn't happening with CS4 files before we upgraded to 5.5, but now it is occuring in both 4 and 5.5.
I've done a little more "experimentation". The problem is not occuring in newly created excel files, so I now suspect the problem is in the supplied files.
It is possible the client is populating their data in a particular way that is affecting the excel sheet.
For example, if I open a new worksheet and copy/paste the cells from the original file, it will replicate the error (so all name ranges list under the first worksheet option when trying to place into InDesign).
However! If I swap the order of the worksheets in the excel file and then try to place in InDesign again, the name ranges now list under the NEW first worksheet.
Has me baffled!
I have managed a solution of sorts...
If I move/copy the worksheet from the original excel sheet into a new excel sheet, it will hold the name ranges when placing into InDesign, even though the original Excel sheet doesn't!
Logic defies me, but at least I can finish this project and supply a work process for the client to receive future files from them.
This "fix" has worked in .xls for both CS4 and CS5.5
It would be a good idea to file a bug. Can you provide a small sample file that demonstrates this problem?