Troubleshoot | values

If you have issues with | (pipe) separated values when using Dynamic Values in Data Correct, please follow this video to solve it. This issue only occurs if you are connecting to a worksheet with multiple marks, WriteBackExtreme will add all values it can find with a | separated. This is handy because you can use the 'Create a separate record per mark' option to generate multiple rows for every selected mark.

The solution is using a helper worksheet with only the relevant values for the dynamic population.