- #Creating hyperlinks in excel for mac mac os#
- #Creating hyperlinks in excel for mac update#
- #Creating hyperlinks in excel for mac series#
then I create the English version with Redokun and change the link of the table to the spreadsheet in $. I create the Italian version (which has a linked table in €). 
A spreadsheet for variables (like the change value between € and $). One of the handiest ways I use this feature is when I have to localize documents to the US market. To unlink the table, just click on the link of the table inside the Links window and select Unlink.Īs you see, linking an Excel spreadsheet into InDesign is quite simple, yet very powerful. Please be aware that with the Create Links When Placing Text and Spreadsheet Files feature active, any time you import an Excel file with the Place command you’ll create a linked table. Important: While the width of your columns will be maintained each time the table is updated in Excel and the changes are applied in InDesign, if you make important changes to the spreadsheet (like adding a row), you will always need to set the header back. As you can see, the updated table lost its header settings.Īgain, select the first row, right-click and select Convert to Header Rows. Here is the table in InDesign before (left) and after (right) the update. You may wonder, “What happens if I add a row to the Excel spreadsheet?” Perfect! The table in InDesign is updated! #Creating hyperlinks in excel for mac update#
Then with an expression, I’ll change the value of the prices and I’ll save the file in Excel.īack in InDesign we see this warning triangle which tells us that the table in the Excel file has been modified.ĭouble-click on the triangle to automatically update the linked table. The first thing we change is the € to the $ symbol. Let’s make this change inside the Excel file.
convert all the prices to their value in dollars. Let’s say that you want to change your prices in Dollars (they are in Euros right now). This is the table we just created importing a spreadsheet from Excel to InDesign. Select the first row, right-click and select Convert to Header Rows. We want to set the first line as the header. This is the table in InDesign linked to the Excel spreadsheet. In this specific case I have already created a Table Style (more about this in part 3), and I am going to use it.īe aware that if in this step you don’t apply a Table Style, any time the linked Excel changes you will lose the layout properties of the Table placed in InDesign.Ĭlick OK and then draw a text-frame in InDesign to place your table. This is important: As we’ve seen in the Import of the Excel file above, here you can personalize a few settings. #Creating hyperlinks in excel for mac mac os#
Let’s click File > Place (Otherwise you can press Cmd+D on Mac Os or Ctrl+D on Windows)Ĭheck Show Import Options in the import window (If it’s not already checked), select the file and click Open to import the Excel file into InDesign. Now let’s import a new Excel file into InDesign. This is how you do so: Set the PreferencesĬlick on InDesign (on MacOS) or Edit (on Windows) in the main menu bar, go to Preferences in the menu that opens, and click on File Handling.Ĭheck Create Links When Placing Text and Spreadsheet Files in the File Handling window and click OK. Leverage Machine Translation to speed up your projects. Invite co-workers and translators to translate your files online. In this case, the best way to create the table is to import the Excel file into InDesign, making sure that InDesign creates a link with the spreadsheet. Linking an Excel spreadsheet to InDesign (the right way) This is NOT something I would love to do any time there is a price update.
either import the Excel file into InDesign back again. If you just import the Excel file into InDesign, then when it’s time to change the prices you’ll have to: Let’s say that you have a product catalogue or a price list and sometimes you need to apply changes to the product prices listed in a table. #Creating hyperlinks in excel for mac series#
If you are not very practical with InDesign tables please have a look at part 1 of this series before reading the post. You can import a linking spreadsheet that you can update from Excel. This is the feature in InDesign I love the most. Be sure to subscribe to our newsletter to keep up with future posts or major updates.
Part 1 is about the three different ways to create a table in InDesign. Note : This is Part 2 of a three-part series on InDesign tables.
0 kommentar(er)
