Explore the possible S7 Excel Connect error messages below. Click on the error message to expand the full description.
Global Errors
#ARR:N/S! – Arrays Not SupportedPossible Cause
- Your actual Excel version does not support arrays.
Solution
- Upgrade your Excel version to Microsoft Office 365, Microsoft Office 2021 or higher.
Argument Errors
#ARG:IP! – Invalid IP AddressPossible Cause
- The given IP address is not a valid IPv4 address.
Solution
- Enter a valid IPv4 address.
Possible Cause
- The given CPU Type is not valid.
Solution
- Enter a valid CPU type.
Possible Cause
- The given rack number is not valid.
Solution
- Enter a valid rack number.
Possible Cause
- The given slot number is not valid.
Solution
- Enter a valid slot number.
Possible Cause
- The given input number is not valid.
Solution
- Enter a valid input number.
Possible Cause
- The given output number is not valid.
Solution
- Enter a valid output number.
Possible Cause
- The given datablock number is not valid.
Solution
- Enter a valid datablock number.
Possible Cause
- The given datablock address is not valid.
Solution
- Enter a valid datablock address.
Possible Cause
- The given marker number is not valid.
Solution
- Enter a valid marker number
Possible Cause
- The given counter number is not valid.
Solution
- Enter a valid counter number.
Possible Cause
- The given timer number is not valid.
Solution
- Enter a valid timer number.
Possible Cause
- The given datatype is not valid.
Solution
- Enter a valid datatype.
Possible Cause
- The given datatype is valid but cannot be used in combination with the given CPU type.
Solution
- Change the datatype.
- Change the CPU Type.
Possible Cause
- The given bit number is invalid.
Solution
- Enter a valid bit number.
Possible Cause
- The given value is not valid in combination with the given datatype.
Solution
- Enter a valid value for the given datatype.
- Change the datatype to match with the given value.