3 Replies Latest reply on Nov 2, 2015 11:15 AM by Peter Spier

    Catalog Design

    lindaq4486791

      I have price list catalog that I need to update frequently. I want to link the excel spreadsheets to the indesign document (tables) and when the excel sheet is updated the catalog will update. Is this possible?

        • 1. Re: Catalog Design
          Mylenium Most Valuable Participant

          You can use variables based on a database or OLE data object query. Also the Place option for Excel files has settings that allow to only import data in existing tables instead of creating an entirely new table. Ask for the specifics in the ID forum(s).

           

          Mylenium

          • 2. Re: Catalog Design
            Peter Spier Most Valuable Participant (Moderator)

            set your preferences in ID to link spreadsheet and text file data before you place the Excel file and you will be asked to to update the link when the spreadsheet is modified. You must either use Table and Cell styles, or do your formatting in Excel, though, or you will lose any format changes in ID when you update.

            • 3. Re: Catalog Design
              Peter Spier Most Valuable Participant (Moderator)

              And you'll likely want to change the prefs back again after placing the spreadsheet so other files don't link automatically.