Participant

Answered

Cell Range Not Showing - InDesign 2020

Forum|Forum|5 years ago
March 3, 2020
13 replies
3053 views

Hi,

I'm a long term user of InDesign, and since the change to 2020, when I'm importing excel files to InDesign, when I try to import information, from a sheet with a named cell range, it doesn't bring it up.

Has there been some change? When I use an older version it works? Can this be fixed at all? I do a lot of work, importing price files into InDesign from Excel.

Thanks for your help, below is an image to show you what I mean, in the 'cell range' it should say 'Cent2020' not just the numbers.

Thank you!
your

This topic has been closed for replies.

Correct answer Ahenn

Know this is an old thread but after about an hour of Googling around and being incredibly frustrated when the "remove spaces" fix above didn't work for me, I figured out what my issue was (using 2024 19.0.1) - numbers in my sheet names. I'm working in rather large files and so I kept my named ranges separated by corresponding page in the document - my Excel file had corresponding pages number in my sheet names.

Originally I had my sheets titled 1 - Cats Dogs etc. Read this thread and replaced spaces with underscores so that it showed 1_Cats_Dogs,. Still no luck. Changed it to just say CatsDogs and then FINALLY my named ranges showed up in the Import Options drop down.

It's worth noting that my range names also excluded spaces and numbers (that wasn't on purpose, but I'd also try removing them there if you have this issue and the problem persists).

A

AhennCorrect answer

Participant

Know this is an old thread but after about an hour of Googling around and being incredibly frustrated when the "remove spaces" fix above didn't work for me, I figured out what my issue was (using 2024 19.0.1) - numbers in my sheet names. I'm working in rather large files and so I kept my named ranges separated by corresponding page in the document - my Excel file had corresponding pages number in my sheet names.

Originally I had my sheets titled 1 - Cats Dogs etc. Read this thread and replaced spaces with underscores so that it showed 1_Cats_Dogs,. Still no luck. Changed it to just say CatsDogs and then FINALLY my named ranges showed up in the Import Options drop down.

It's worth noting that my range names also excluded spaces and numbers (that wasn't on purpose, but I'd also try removing them there if you have this issue and the problem persists).

Rishabh_Tiwari

Community Manager

Hi,

Thank you for reaching out and sharing the solution that worked for you. I am sure it will help other community members. If anyone else is experiencing a similar issue, you can also refer to this discussion.

Thanks

Rishabh

F

flair21

Participant

I was running into the same issue. I had defined all of the cell range names in my spreadsheet, but none of them would appear when I went to import into InDesign. One commenter mentioned changing the sheet name to remove any spaces. I did this and replaced all of the spaces with underscores. That seemed to fix the issue. Now all of my defined cell ranges are appearing. I hope this helps someone!

kaichilver

Participant

This is still an issue in 16.3.2
I tried removing any spaces from the sheet name with no luck.

D

defaultmppjw0b9u5ji

Participant

I had been having this same issue. I tried removing all spaces, underscores, and hyphens from worksheet name and range name. Seems to be working. At least for now.

S

Saad5C21

Participant

Same problem here . my excel Sheet contains 14 names ranges but on Indesign it show only 12 named ranges

.

B

bump_and_run

Known Participant

This is still not working (16.1) and I don't think the Adobe person knows what we are talking about. Their example shows the standard choices, not custom cell ranges. This is a HUGE problem.

jacquio57852915

Participant

Still not working. Surely they can get their acts together aand fix this.

F

Felix Eklöf

Participant

Had the same issue, solved it by replacing all spaces with underscores in all sheet names. Then it worked like expected.

K

kschubert@cornellpump.com

Known Participant

Since the 2021 version came out, it has worked as it had before for me.

D

Desmo

Participant

Same here....need to import the Defined Names but nothing shows up in the list. I thought it was me going mad but clearly the latest version is broken.

A

Archeantus

Participant

I'm running 16.0 and can confirm that this still is not working.