1 person found this helpful
InDesign does support linking to Excel and it works far better than the wonky OLE that PM used.
Check your preferences and enable Create Links When Placing Text and Spreadsheet Files which you'll find in the File Handling section.
Thank you that was very good to hear.
I dont seem to get it to work though, most likly becouse of my lack of knowledge about ID and not your advice.
I checked the box you mentioned.
I then drag and drop (also tried ctr+c and ctr+v) a cell from excel to InDesign.
The textbox in ID doesnt update when i change the cell in excel though, it also doesnt show up in the "links-panel" like pictures that are links.
1 person found this helpful
Linking means File > Place.. not copy/paste or drag/drop from Excel.
That said, you haven't told us which version of ID you use, but if it supports Conditional Text, you might want to look at that as an option. Conditional text would allow you to have all the text inthe file at the same time, but hide those languages that you don't need at any particular moment.
Oh i see, that explains why it did not work. thank you!
I use ID CS5.5 Version 7.5 (I think its the newest one), if this version supports conditional text it seems its an option that would be interesting to look into. I imagine it works as layers? I choose to show only the english/german/russian/.... layer of text so to say?
Does it work in the way that i make one textbox and write 3 different text's (languages) in that box and it only shows one or do i work with 3 different textboxes on top of eachother? i guess it would also be possible to link all the english/russian/german text together so i change them all at once in the entire catalog?
Thank you so much for the advice and patience, it's very helpful.
You can place a named range or you can specify the range.
There's a bug with XLSX files that prevents the named ranges from working but saving back to XLS is the workaround.
Thank you very much for the help, both of you, just have one more question.
The old PM links in the catalog to excel are not imported into ID, picture links are but not excel ones. This even after i close all open projects and change the setting about links from spreadsheets in ID, when i then open the catalog the links to excel dont show up as links, just as textboxes.
This would be a huge help if there is some way to get these links to work in ID without having to "redo" 300 pages. This would be good during the time we update to using conditional text, becouse that seems like a solution we should have used from the beginning.
Thank you in advance
Are the "links" really linked, or are they embedded. PM liked to embed things by default (and it's really important to change images from embedded to linked in the link manager in PM before converting in ID). Since PM used the really strange OLE routines for spreadsheets, I'm not sure that they will translate at all as real links for ID. You may be stuck.
Converting PM docs is really hit or miss, depending on the structure of the PM file. Some will be near perfect, others useless, but you should always count on doing some work in ID.