Description

When running a chain script, I see some values write to my log column in Excel, but when the script switches, the log column for the previous script disappears.

Cause

This issue can be caused when the data file which is being used is being referenced in different ways by the script.

For instance, if the first script in a chain references a data file as S:\Temporary\DataFile.xlsx and the second script refers to the data file with a different path like \\SERVER-NAME\Temporary\DataFile.xlsx, the script will treat the data file as a new file, even if both of the paths are referencing the same file.

Solution

To resolve this issue, make sure that all of the scripts within the chain are referencing the data file in the same way.  It should not matter which type of path is used, but the path used must be consistent.