A little experience with Excel linked un InDesign:
The only way I have been able to link individual cells from excel to Indesign is by putting each cell from excel in individual text boxes in InDesign and it will have a link in the links window
(I have not been successfully placing these cells InDesign Tables):
Place/Show Import (Choose the cell such as: B2) / Unformatted Tab Text
I hope this has been helpful
Thanks for the reply, that's how I've done it, and it works flawlessly.
The Excel files into tables I can do with ease.
Like you, I can have a seperate text box with a block of text that is linked to a cell in an Excel file, but I can't seem to get that cell content into a conventional block of text.
Does anyone else have any inspiration?
I have used this method:
Pasting the individual text box into the conventional block of text.
Sorry: You first have to place an empty text into the block of text and then import the cell.
Yes the pasting method works well, but I'm trying to retain the linked aspect of this.
When the Excel file gets changed I need the many references to change when the Excel file is updated. The pasting method is too manual and prone to human error.
Once again, thanks for the input.
Will you please clarify the "empty text into the block of text" part of your post.
You lost me there
1 person found this helpful
Sorry: You first have to place an empty text box into the block of text and then import the cell and make sure the text is bottom align or align as you wish copy to aligh
That was the solution!
An inline table! I made a small text box, linked the cell, then made that an inline element within the paragraph of text. Then it's just styling it and design.
Thanks very much