Dynamic input (sheet is not specified issue)

[joannasokolowska]

Hey,

I have an issue with dynamic input tools since I keep receiving the error "No sheet specified" even I have the sheet selected. 

I need to use only the last file save in the folder therefore I use Directory and Dynamic input tools. 

I attached printscreens to show the settings. 

Thank you in advance!

Asia

[IraWatt · Accepted solution]

Hey @joannasokolowska,

when you overwrite the full file path you need to include the sheet name in the file path. You can do this by adding it to the end of the excel workbook name eg. "Example.xlsx|||Sheet1" The three ||| are needed before the sheet name.

To get the sheet names dynamically you can use the dynamic input tool and just import the sheet names then append that to your file path field for your final dynamic input.

[joannasokolowska]

Thank you! It fixed the issue! 

[IraWatt]

No worries :) glad it worked for you !