Cell Range Not Showing - InDesign 2020

New Here ,
Mar 03, 2020

Copy link to clipboard

Copied

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! 
Screen Shot 2020-03-04 at 9.24.39 am.pngyour 

TOPICS
Bug, Import and export

Views

363

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Adobe Community Professional ,
Mar 03, 2020

Copy link to clipboard

Copied

Hello, are you running the last update of ID ? the 15.0.2 

After if you have the last version, just try to reset preferences :

Shut down ID and Hold the keys CMD+option+control+shift when you start ID, a pop up appear, clic ok ad try to improt your cell range and let us know if it's ok (or not)

 

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
KELarnec AUTHOR
New Here ,
Mar 03, 2020

Copy link to clipboard

Copied

Hi, I am running 15.0.2.

 

I just did what you said, it's still not working 😞 

 

Any other suggestions? 

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Adobe Community Professional ,
Mar 03, 2020

Copy link to clipboard

Copied

I just tried it out and it is still working as expected on 15.0.3. (This week's patch.)

Screen Shot 2020-03-03 at 4.35.01 PM.png

Let us know if resetting prefs works. Also, there are various levels of resets. See the complete list here: https://www.rockymountaintraining.com/adobe-indesign-rebuilding-preferences-cache/.

 

~Barb

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Jul 10, 2020

Copy link to clipboard

Copied

Did you find a solution for this? I am running into the same issue.

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Aug 06, 2020

Copy link to clipboard

Copied

I am also having this issue. I have been importing named cell ranges from Excel for years, but with my latest InDesign build (15.1.1), this function no longer works. If I import from an .xlsx file, the named ranges are missing. If I import from an .xls file, the named ranges appear but will not import.

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Explorer ,
Aug 20, 2020

Copy link to clipboard

Copied

I am also having this issue since updating to InDesign2020, 15.03. I can import the named ranges from an .xls file, though.

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Adobe Employee ,
Aug 29, 2020

Copy link to clipboard

Copied

Hi All,

 

Sorry to hear about your experience. This is really unusual. I'd request updating your InDesign to the latest version(v15.1.2) and see if it helps.

 

Regards,

Ashutosh

 

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Oct 22, 2020

Copy link to clipboard

Copied

Did anyone find a solution to this issue? I have updated my InDesign and I am still not seeing my named cell range

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
Oct 29, 2020

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Desmo LATEST
New Here ,
Nov 26, 2020

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more