Inserting Excel Tables into Data Driven Pages

Discussion created by mcdka004 on May 18, 2011
Latest reply on Oct 19, 2012 by jbarrette-esristaff

I am creating a map series and would like to insert an excel table for each page. (in ArcMap10) It would be great to have the excel spreadsheet to dynamically update for each map page but I haven't been able to work out how to do this.   The way I am going about it (and probably not the most efficient) is by creating a table in excel for each map page.  I then copy and paste the excel table into word and save.  In ArcMap, I am then going Insert>Object and inserting the word document into the map (as a link). The table comes in correctly.  (I have tried to link directly to excel but it never works properly as it won't recognise the data range I am interested in).

When I insert the tables I insert them into data View rather than layout view in a logical location for each page.  This means that when I print the series, the tables will be different for each page.  I am however now having issues with my workspace and I am guessing that having lots of linked excel tables in an MXD is causing problems.  I could go back and copy and paste the tables as an image rather than a link but perhaps that will cause the similar problems. There are approximately 150 maps in each series (and we are doing about 17 series).  Not every map page has an attribute table, only about half.   Has anyone done something similar successfully or have a better solution?

Thanks very much for your help!