I am attempting to test my workflow with past data to see if I still obtain the desired outputs. When attempting to change the input file to a new excel file, under <List of Sheet Names> the sheet I need does not show up.
The excel file I am trying to input has the exact same format as the file currently in the workflow (that works), it just has different data. The excel file is saved in .xlsx format, not .xls. The excel file is also not open when I am trying to input the sheet.
I can't seem to figure out what's going wrong. I'm hoping it's a simple fix and I'm just overlooking it because my morning coffee hasn't kicked in. Thank you in advance for any help!
