


When making use of the Content Placer tool to place Enterprise Excel files, take note of the following Note: For more information about these tools, see Adobe InDesign Help Linked Content. Placed Excel files that are stored in Enterprise can be collected by using InDesign's Content Collector tool and subsequently placed using the Content Placer tool. Click on an existing frame to place the Excel file in that frame.Draw a frame to place the Excel file in it.
Data merge excel indesign full#

Multiple Excel files can be placed by loading them into the so-called 'place cursor' of InDesign (also known as the 'place gun'). When multiple frames are selected, the Excel file is only placed into the frame on which the file is dropped This happens when the frame that you are targeting is checked-in and therefore locked for editing. Troubleshooting The Excel file is loaded into the place cursor and not in the frame, or the Excel file is placed in a new frame. Right-click the Excel file in the Smart Connection panel or the Dossier panel and choose Place.Double-click the Excel file in the Smart Connection panel or the Dossier panel.Drag the Excel file onto the frame from one of the following locations:.(Optional, only when the frame is checked-in.) Check-out the frame in which the Excel file is to be placed. Note: Replacing the full content of an article component with that of an Excel file will result in a placed article that is not linked to the Excel file. Preferences > File Handling > Create Links When Placing Text and Spreadsheet FilesĮxcel files can be placed one-by-one or in groups and can be placed as a new frame or in existing frames. To make sure that a link exists between InDesign and the Excel file, select the following preference: Make sure therefore to upload the Excel file first so that it is available in Smart Connection for placing on the layout. Uploading an Excel file to Enterprise can only be done by using Studio, not by using InDesign. Converting the placed Excel file into an Enterprise article.This article describes all aspects of working with Excel files that are stored in Enterprise: When changes are made in the spreadsheet, the placed file can be updated accordingly. Excel files that are stored in Enterprise can be placed on a layout while maintaining a link to that file.
