If we can get access to the raw hidden excel data I have a high degree of confidence that we can come up with a dynamo / python solution to add parameters to the families based on the excel data then create filters that ‘watch’ for those parameters. That whole revit process could be pretty easily automated. The bottleneck is getting access to the source data from that Tally database.
I’ll do some investigation into this and post if I find anything. In the meantime if anyone has found a reliable hack for this please share. If we get access I’ll happily share the dynamo automation with the larger community to make all of our lives easier 