Skip to main content
G
GardensA
Participant
November 24, 2021
Question

Cell range not showing - InDesign 2022

  • November 24, 2021
  • 5 replies
  • 1688 views

I've seen similar issue report for Indesign 2020. I'm trying to link an excel table (xlsx) and have named a cell range in excel. When I try and Place the excel spreadsheet and use the option to select cell range my defined cell range in excel does not show in the dropdown.

I'm using Mac BigSur 11.6, and InDesign 2022 v17.01

 

Has anyone had similar issues/found a work around for these defined cell ranges

    This topic has been closed for replies.

    5 replies

    V
    Valerii29494402og67
    Participant
    August 29, 2023

    InDesign can place spreadsheets saved in either the new .xlsx format, or the older .xls format. But named ranges will only appear in InDesign if you save the file in the older .xls format.

    Source

      Dave Creamer of IDEAS
      Community Expert
      Dave Creamer of IDEASCommunity Expert
      Community Expert
      August 29, 2023

      That article is 13 years old. XLSX named regions are working fine on my system.

      \

      David Creamer: Community Expert (ACI and ACE 1995-2023)
      V
      Valerii29494402og67
      Participant
      August 29, 2023

      For me it didn't work, that's why I ended up here. Indesign 18.5 x64, Windows. Upon placing from .xlsx there were no defined ranges in dialogue's Cell Range dropdown. When I saved the file to .xls format ranges appeared in the dropdown.

       

      madisonr92652107
      madisonr92652107
      Participant
      June 2, 2023

      I am having the same issue. All cell ranges are correctly set up - however, the option to select the defined cell range is not available.

      *Using Indesign Version 18.3

      Dave Creamer of IDEAS
      Community Expert
      Dave Creamer of IDEASCommunity Expert
      Community Expert
      June 2, 2023

      You should start a new post to get more responses. This one is a couple of years old.

      David Creamer: Community Expert (ACI and ACE 1995-2023)
      L
      latTHErat
      Participant
      December 3, 2021

      We have the same problem here. When will this issue be fixed??

      Dave Creamer of IDEAS
      Community Expert
      Dave Creamer of IDEASCommunity Expert
      Community Expert
      November 24, 2021

      The named ranges are listed on a per-sheet view--that is, you don't see all the named regions at once. Make sure you have the correct worksheet selected above. 

      David Creamer: Community Expert (ACI and ACE 1995-2023)
      G
      GardensAAuthor
      Participant
      November 24, 2021

      Hi thanks - yes I have the correct worksheet selected and the issue still remains

       

      Dave Creamer of IDEAS
      Community Expert
      Dave Creamer of IDEASCommunity Expert
      Community Expert
      November 24, 2021

      The cell range is working on my system. I'm currently on Windows, but I'll try on my Mac when I can.

      Just another double-check--can you see the named region in Excel, and does it select properly?

       

      I'm running into the formula issue too. It only appears with text-based formulas so far. I was able to save down to an .xls and it worked. (See if that resolves the named region issue too.)

       

      I'm tending to think the issue is with Excel since I had trouble getting the Concatenate, Concat, and Text formulas work display properly in Excel when using the .xlsx format. (Word is also have a problem with hyperlinking its TOC when exporting/saving to PDF.)

      David Creamer: Community Expert (ACI and ACE 1995-2023)
      G
      GardensAAuthor
      Participant
      November 24, 2021

      Also - as an aside - if my excel cell has a formula such as =CONCATENATE(B5," - ",C5) the values from this formula do not show in the inDesign

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