I'm hoping to embed a single Excel cell into a text box and have that value change within the text box as the linked Excel file is updated. Imagine the following: "... this is an important number 123456 and the text continues here..."
So far I have been able to sucessfully change the preferences so that a linked Excel file is linked and can be updated, but that is a whole file, or range of cells in it's own table.
Can I have JUST the text in the cell appear (with no discernable denotation of its attributes) within the block of static text and be linked to allow for updating in the Links panel?
BTW why is it that sometimes only the first two columns appear in the table?
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?
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.
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
Europe, Middle East and Africa