I'm using linked tables imported from Excel into InDesign. There are multiple tables the InDesign document is pulling from the Excel file worksheet.
I would like to relink to another Worksheet from the same Excel file that will completely update every table in the document, but there doesn't appear to be a way to change that path. When I try to relink, it asks me for all new cell coordinates and sheets, or tells me it can't import that data.
The layout in the two worksheets is exactly the same, they just have different data.
Rename worksheet 1 to worksheet 3 and worksheet 2 to worksheet 1.
Thanks for the reply.
I did figure that part out. But what I'm looking for is to have one linked Excel file serving a number of InDesign files by using Worksheets 1, 2, and 3. This way, if anything needs to be updated, only the Excel file will need the update.
Everything else will automatically update.
Rather than resetting each individual table for each new InDesign file, I just want to change the targeted worksheet.