0 Replies Latest reply on Aug 2, 2012 11:21 AM by MOD_Adobe2

    Updating Linked Excel File: Changing Worksheets

    MOD_Adobe2 Level 1

      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?