When connecting to a S7-1200 or S7-1500 CPU using S7 Excel Connect, make sure “Permit access with PUT/GET communication from remote partner” is enabled.
In TIA Portal go to the CPU’s “Protection & Security” and open the “Connection mechanisms” panel. Tick ”
Permit access with PUT/GET communication from remote partner”. Download the changes to the CPU.
