I am trying to create an excel sheet that is updated automatically when the features of a shapefile are updated. I know the shapefile's .dbf file is updated but I need the excel sheet to be formatted for presentation purposes (borders, bold meaningful column headers, etc). Right now I have created an excel sheet that links to the fields of the dbf but that isn't perfect...ie when a feature of the shapefile is deleted you now have excel fields linked to dbf fields that no longer exist. Does anyone have any better ideas?
I have done a similar task for presenting housing density schedules, I pulled in all of fields and entries into excell then used another sheet in the same book with if statements to summarise the data this avoids references to specific cells.