Defined Names in .xlsx files Do Not Work When not specified in A1:Z9 format
- Create an excel spreadsheet
- Create a table (example table below)
- Name a range:
- Insert^Name^Define Name
- Use the default "Refers to:" (=Table1[#All])
- Do this a second time
- Use a specific range that is the same area (=Sheet1!$A$1:$C$11)
- Save the file
Attempt to Place in Adobe. Note that the second range is available for placement, the first is not. It seems that any named ranges that don't specify cells, and instead specify other placeholders (i.e. =Table1[[#All],[Description]:[Amount]]) do not work.
Tyler Andersen commented
Additionally, if a Sheet name has a space in it, then the Defined Name will not appear.