The Anaplan XL Bulk Connection Editor is a tool that can be used to remap many Anaplan XL Reporting Excel workbooks at once.
You add the workbooks you need to remap at the top, then select workbooks sharing connections. You can then change all the connection details at the bottom.

As you change details, all the connections where all the details are the same are updated. Select Save All when you have finished editing.