We have 15,000 AF elements, each of which has around 14 attributes with PIPoint data references. These were originally derived from the template but then got hard-coded (just don't ask!).
The tag names in PI have now changed and we have updated the template, but of course all the elements have deviated from the template.
We have tried bringing this stuff into Excel but we just get out of memory errors (on a client with 8gb of memory!)
Is there any way of doing a mass change to get these attributes to drop their hard-coded settings and revert to the new template?