×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Link Indesign with Excel

Link Indesign with Excel

Link Indesign with Excel

(OP)
We have a project that involves a huge map with 300 businesses marked on it with numbers. Beside the map is the numbered list with the business names. The numbers have to be in order and the business are listed alphabetically by town so when a new business is added to say #37 all the numbers following it have to move on the map.

We're trying to come up with a way to have all the businesses and map numbers on an Excel sheet so it can be easily updated but we need a way to link the excel sheet to the individual numbers on the indesign map. We can't link to a specific cell though because if another row is added then the location on the map will be wrong. Is there a way to do this? Is there a way to attach a hidden ID to an Excel row and link to indesign that way?

Any help with is much appreciated.

RE: Link Indesign with Excel

I have the same project as Ashley, any idea how to do this??


ashleyodd (TechnicalUser)      
24 Sep 08 12:34
We have a project that involves a huge map with 300 businesses marked on it with numbers. Beside the map is the numbered list with the business names. The numbers have to be in order and the business are listed alphabetically by town so when a new business is added to say #37 all the numbers following it have to move on the map.

We're trying to come up with a way to have all the businesses and map numbers on an Excel sheet so it can be easily updated but we need a way to link the excel sheet to the individual numbers on the indesign map. We can't link to a specific cell though because if another row is added then the location on the map will be wrong. Is there a way to do this? Is there a way to attach a hidden ID to an Excel row and link to indesign that way?

Any help with is much appreciated.  

RE: Link Indesign with Excel

This is a massive thing to setup.

I will try and look at a way to do this and hopefully post a video on the method if I find a way.

In the mean time could you perhaps use a service like yousendit to send some sample files that I could work with, and perhaps an indication in the file of what is needed.

If you follow the link below you can see my contact details.

Regards

http://www.doozler.blogspot.com/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close