Skip navigation
WendyOkada
Currently Being Moderated

Adding rows to linked Excel tables in InDesign

Aug 10, 2012 1:57 PM

Hi there, I have figured out how to link Excel documents to tables in InDesign, but is there a way to add additional rows to the tables in InDesign?  If I do that, whenever the Excel link is updated, it deletes the new rows I've added.

 

We have data that goes in the cells below the linked table and it needs to be in the table so that they'll resize automatically when longer or shorter data is pulled in (vs. just being a totally separate text box/table outside of the linked one).

 

Help!

 
Replies
  • Currently Being Moderated
    Aug 10, 2012 2:10 PM   in reply to WendyOkada

    Have you tried adding blank rows to the table in Excel and using a named range?

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 10, 2012 2:20 PM   in reply to WendyOkada

    How about nesting two tables into the cells of a two row/one column table in ID?

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 10, 2012 2:33 PM   in reply to WendyOkada

    I actually almost never work with tables, especially linked ones, so I'm basically spitballing here. Bob is more likely to know if this is doable, and how.

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 10, 2012 2:46 PM   in reply to Peter Spier

    Can’t say I’ve ever tried placing a table into a table but I don’t see any reason why it wouldn’t work.

     

     

     

    Bob

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 10, 2012 2:55 PM   in reply to Bob Levine

    I just ried, and it doesn't seem to link....

     
    |
    Mark as:
  • Currently Being Moderated
    Aug 10, 2012 2:58 PM   in reply to Peter Spier

    What if you placed it, cut it, and then copied it?

     

     

     

    Bob

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points