Partial Data When Source is Closed

[taran42]

I am experiencing this really strange issue. I have an .xls data source. If the data source is open (meaning I have the actual Excel file open on my desktop) when I am running my workflow, then all of the data imports in properly. However, as soon as I close the data source (closing the Excel file), then part of my data disappears. See the screenshots below. Does anyone know what might cause such a thing?

 

 

[taran42 · Accepted solution]

I figured out why this is occurring. The data that is not being shown is an Excel formula - I did not catch that at first. I suppose that when the sheet is open, Alteryx can read the data as the formula has parsed it at that point.