2 people found this helpful
Instead of copy from excel and paste images in Indesign, do one thing
1. Open your Excel file, click File tab, choose Save As, in the Save As window, click the drop-down menu labeled Save as type:, scroll down and choose Web Page (*.htm;*.html), Click Save.
When a web page is saved in a computer two files are actually generated. One is the html file, and another is a folder that contains all the images and other component files that are a part of the web page.
2. Change the Excel file extension (only available with .xlsx) as a RAR file, For example, change Products.xlsx toProducts.rar, extract the Products.rar file, you will see 3 folders (_rels, docProps and xl) and 1 xml file ([Content_Types].xml), open xl folder, open media folder, you will see all the images in the media folder.
3. Open up the Indesign file instead of copy and paste, Placed the exported excel images to Indesign to have a linked and there will be no issue at all.
philippanmei Thank you for that information. While that does help provide all the images to place in the table, I am still having an issue with the placed photos disappearing from the table when the text within the linked excel file is updated. Any idea on how to set up the photos in the table so that they remain after the linked table is updated?
Don't place the image directly into the cell just do place the image somewhere and drag the image and fit to the cell and keep anchor into the cell.