Join Anne-Marie Concepción for an in-depth discussion in this video Automatically update InDesign tables from Excel, part of Managing Conversions Between Adobe CC and Microsoft Office.
- View Offline
- [Voiceover] Here is a neat feature…that you might find in handy.…Instead of just placing an Excel spreadsheet data…into InDesign and formatting it as a table,…as I showed in the previous video.…You could also link, to that external Excel file,…so that as people change the data in Excel file.…Like here is the Excel file,…if they change something here…and save it,…you'll be notified in InDesign that the data is different.…Here is the table that I created from that data…And then you can easily just click one button…to update all of the changed data,…and it will automatically update…without losing your formatting.…
Now it's not something that…most people need to do,…usually just bringing in once…and then format it.…But if it's something that…you know it's part of your work flow…the people are constantly updating the data,…and you need to constantly update your InDesign file,…it can come in extremely handy.…But let me show you how to do that.…The're two things you need to do.…The first one is you need to create a Table Style.…
She begins with an overview of the major differences between the suites and platforms and between Office for Mac and Office for Windows. From there, she breaks down common challenges such as importing and editing Adobe art and text in PowerPoint, using PowerPoint elements in Adobe apps, integrating Excel data and charts in Adobe apps, and more. Find solutions to your most common challenges, improve your workflow, and get the results you want.
- Understanding essential differences in the way Office and Adobe CC treat fonts, graphics, and color
- Using proprietary Adobe-to-Office conversion software
- Using the "secret weapon," Acrobat, to do conversions
- Editing Illustrator graphics in PowerPoint
- Extracting PowerPoint art for use in Adobe apps
- Creating InDesign tables from Excel spreadsheets
- Importing Excel data into Illustrator's chart worksheet
- Recreating InDesign layouts as editable Word files
- Converting Word art into high-res vector files