Skip to main content
K
KE_Larnec
Participant
March 3, 2020
Answered

Cell Range Not Showing - InDesign 2020

  • 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). 

    13 replies

    Show previous replies
    M
    MissyS1414
    Participant
    July 10, 2020

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

    D
    deanhorn
    Participating Frequently
    August 6, 2020

    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.

    Barb Binder
    Community Expert
    Barb BinderCommunity Expert
    Community Expert
    March 3, 2020

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

    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

    ~Barb at Rocky Mountain Training
    Alexandre Becquet
    Community Expert
    Alexandre BecquetCommunity Expert
    Community Expert
    March 3, 2020

    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)

     

    K
    KE_LarnecAuthor
    Participant
    March 3, 2020

    Hi, I am running 15.0.2.

     

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

     

    Any other suggestions? 

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices