DDE Excel file location

DDE Excel file location

I have several programs that have 50 ish lines of DDE export in the program. At some point our server paths changed, switching what was for example the "Z" drive, to what is now the "X" drive. This has made it so I have to change the path in every DDE line of each program. Is there a way to change to path in one single location?