We have found that there is a bug in the ExcelLink software for reading or writing a range of DM[] variables when multiple PLC IDs are configured for different actions in the same site.
When you define different PLC IDs for each active action that is reading/writing a range of DM[]s in a site, data will only be exchanged between ExcelLink and the PLC defined in the last action in the list of actions. The other PLCs defined for previous actions that are reading/writing a range of DM[] data will exchange the same data as the PLC defined in the last action. Thank you for pointing this out, we have forwarded the information to the software development team.
A workaround solution is to create a duplicate site for each PLC on the RS485 network tied to the same TLServer, instead of defining different PLCs for actions in the same site. Each site should have a different name, but the same local host IP address (127.0.0.1) and the same login information.