Defined Names in .xlsx files Do Not Work When not specified in A1:Z9 format
To Reproduce:
- 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.
1
vote
Tyler Andersen
shared this idea
-
Additionally, if a Sheet name has a space in it, then the Defined Name will not appear.