From the course: InDesign Secrets
Join today to access over 22,500 courses taught by industry experts.
037 Updating a linked table without losing formatting - InDesign Tutorial
From the course: InDesign Secrets
037 Updating a linked table without losing formatting
One of the holy grails of InDesign is being able to place something that a coworker creates in Excel, a spreadsheet, and then placing that in InDesign, where it comes in as a table, applying beautiful InDesign formatting to it with paragraph styles, and then when the coworker updates the Excel spreadsheet and lets you know, hey, we have changed some of the data. Then you could come over here and update this in InDesign without losing any of that formatting that took you so long to do. First of all, when you place a text file, it doesn't become linked. So if I open up the Links panel, there's nothing here. So even if my esteemed colleague said, I updated that Excel file that you placed, there is nothing to update here. You would actually have to place it from scratch and then reapply all your formatting. First thing you want to do to make this work is you want to turn on the option to create links when placing documents and spreadsheets. It's not turned on by default because just think…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
161 Keeping page numbers on top of master items3m 55s
-
162 Adding automatic currency symbols in a table cell or before text3m 50s
-
163 Make a pop-up footnote for your ebook3m 48s
-
164 Deleting tabs at the beginning of paragraphs and applying a paragraph style3m 10s
-
165 Five InDesign Presentation tips6m 28s
-
-
-
089 Three great Object Styles for any designer8m 1s
-
090 Choosing alpha channel image transparency2m 25s
-
091 Adding and reading metadata for InDesign files3m 25s
-
092 Adding ALT tags to your images6m 59s
-
093 How to Place & Link a text frame's text but not its formatting7m 4s
-
094 Setting the baseline position of a caption2m 39s
-
-
-
051 Five things that should be in every new file5m 19s
-
052 Forcing EPUB page breaks with invisible objects6m 21s
-
053 Understanding component information6m 39s
-
054 Creating running heads using section markers4m 16s
-
055 Making a font with InDesign using the IndyFont script5m 20s
-
056 Finding where that color is used7m 17s
-
-
-
037 Updating a linked table without losing formatting5m 18s
-
038 Creating electronic sticky notes4m 49s
-
039 Moving master page items to the top layer for visibility2m 48s
-
040 Five guide tricks that will impress your coworkers6m 18s
-
041 Letting InDesign add the diacritics4m 21s
-
042 Using single-cell table cells for custom paragraph formatting6m 2s
-