I've seen similar issue report for Indesign 2020. I'm trying to link an excel table (xlsx) and have named a cell range in excel. When I try and Place the excel spreadsheet and use the option to select cell range my defined cell range in excel does not show in the dropdown.
I'm using Mac BigSur 11.6, and InDesign 2022 v17.01
Has anyone had similar issues/found a work around for these defined cell ranges
Also - as an aside - if my excel cell has a formula such as =CONCATENATE(B5," - ",C5) the values from this formula do not show in the inDesign
The named ranges are listed on a per-sheet view--that is, you don't see all the named regions at once. Make sure you have the correct worksheet selected above.
Hi thanks - yes I have the correct worksheet selected and the issue still remains
The cell range is working on my system. I'm currently on Windows, but I'll try on my Mac when I can.
Just another double-check--can you see the named region in Excel, and does it select properly?
I'm running into the formula issue too. It only appears with text-based formulas so far. I was able to save down to an .xls and it worked. (See if that resolves the named region issue too.)
I'm tending to think the issue is with Excel since I had trouble getting the Concatenate, Concat, and Text formulas work display properly in Excel when using the .xlsx format. (Word is also have a problem with hyperlinking its TOC when exporting/saving to PDF.)
Hi, thank you again for your help. Sorry for the delay in reply.
The cell range works fine when I'm just in excel. I will try again and use the file link as xls. Thanks again.
We have the same problem here. When will this issue be fixed??