Right click the file name in the links panel and choose go to link.
That will show me where the table is located in my Indesign file, but I would like to use it the other way around: click on any table in my design and check which cell range was selected in the import options when I placed it at that location.
At the moment, my collegue is in charge of updating the excel sheets (and sometimes changes the cell range names too, unfortunately) So I would like to know which cell range Indesign is looking for in the linked excel sheet. It just says it can't find the right cell range, and I need to reimport the entire file.
Hope this makes any sense
Been a while since I’ve done this.
When there’s an updated link, does it show for all instances? If so, I can’t think of anything off the top of my head that would show you which instance was updated.
1 person found this helpful
I'm starting to believe there isn't any
When there's an update, it does show for all instances. But when I right-click to update the links, Indesign will only update the instances if it can find the original cell range in the updated file. When my collegue changes a tab name or cell range, the link is lost, and I need to replace the file manually.
As far as I know there is no way to check what Indesign is looking for in the linked excel.
Right. If you change the structure you can’t update the link.
Have you discussed this with your colleague?
Of course - but I guess sometimes it just slips her mind
I might try and suggest this to Adobe for a future update - I can't be the only one with this problem.
2 people found this helpful
They should add cell range info in the links panel. This can prevent redoing a lot of work if someone change the cell range or sheet name. What would be even better is to be able to update cell range