I am producing some maps for a client who owns a lot of water and sewer assets. The data supplied by the client has automated symbology which imports when dragging them in from the geodatabase based on unique fields. The number of feature classes is close to 60 and i have gone through and done a select by location based on my Data Driven Pages polygons I've set up, then 'created a layer from selection' for all of these. this helps to improve the performance/speed as it reduces the number of assets down from over 1million to a few thousand just in my areas that need to be mapped (50 x 1:1k maps).
The query I have is that i'm producing a separate 'legend' map which covers all assets that are shown across all the maps. the symbology of each of these feature classes in the table of contents (and therefore legend) doesnt change when i set a definition query or selection query. some of these feature classes are symbolized by up to 3 fields (symbolize by unique features, many fields) and have 20 different symbols, but when i look at the attribute table only 1 of these symbols is present and the remaining 19 are not shown on any of the maps (just as an example of one of them).
Is there a way to automatically update all these feature classes in my table of contents to only show the symbolised features present within my 50 maps?