I have a series of InDesign documents with linked Excel files filled with area-specific rate tables.
The Excel files contain several different areas separated into worksheets. Each worksheet layout is identical. Only the data in the tables changes.
I have a template file set up pointing at Excel File A Worksheet 1, and I would like to redirect the link to Excel File A Worksheet 2.
The problem is that when I ask InDesign to relink, it asks me for the cell coordinates all over again. This ruins my efficiency.
Is there a way to update only the linked file's worksheet, from Excel File A Worksheet 1 to Excel File A Worksheet 2, without resetting the cell coordinates?
Retrieving data ...