Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you do a lot of work with tables in InDesign, then you'll be happy to hear that now header rows and footer rows are maintained after you update from linked Excel files. And if that sounds like a bunch of gibberish, or it sounds vaguely familiar, let me recap what that's all about, and then I'll show you how it works. First of all, you have always been able to import Excel spreadsheets, like this simple one right here. You can just place that table data.xlsx file and then format that spreadsheet into a table. If you remember to turn on the linking option, Link to Imported Spreadsheets and Text Files, which is an option in Preferences, then when you place it, it becomes link to the table that you format.
So here you see we have a link to that table data, and that's why we have the little link badge here on our table. Let's zoom in a bit. So this is still all old news, and the beauty of linking to the Excel files, as any table person will tell you, is that when somebody updates that Excel file, you know, the boss or the person in charge of updating all the data, and they save changes, then you're notified that your table is out of date in the Links panel. That's where you'd have to look in the old versions, and now that we have our link badges, we can see it right on the object.
Now the problem was that if you formatted your table correctly using cell styles and table styles and you also had a header row--you know, one of those rows that appear at the top of every table--if it's threaded among multiple text frames, then when you would update the Excel file, you would lose the fact that this is a header row, and it would revert to really bad formatting, because you actually have to select that row and specify that it's a header row from here, which it already is. All right! So we got that, and we are clear on that? Now the deal is that it doesn't happen anymore.
Our header rows will be maintained after we update. Again, none of this works if you use local formatting to format everything. You have to remember to go to the Styles panel and create table styles. This is a materials table that uses cell styles, and all these have been formatted with cell styles. So as long as you're using a style- driven workflow, you will be able to maintain all of this work, even after you update the data. So let's try it out. I am going to go to Excel, and let's change the Day for Fashion Design to Tuesday and Thursday, and then I'll save my changes. And now let's go back to InDesign, and we see that it's out of date.
I can click on the out-of-date badge with my Selection tool. And the first time that you do this, you are going to get this warning that says, are you sure, because you have made some changes to this data since you have first imported it, and you're going to lose these edits, with the exception of changes applied to spreadsheets through cell or table styles, when you update. So you can ignore this if you've been using styles. Click Yes. There it is. Nice and simple. All right, no-brainer. You will be able to move a little bit more quickly through your table updating by not having to constantly reapply header and footers to your tables in CS6.
Get unlimited access to all courses for just $25/month.Become a member
119 Video lessons · 49707 Viewers
117 Video lessons · 36974 Viewers
113 Video lessons · 81095 Viewers
65 Video lessons · 10299 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.