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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.