No sheet specified, you must specify a sheet

[Stokesy]

Hi guys

I've seen one or two posts on this and they all seem to marked as Resolved however the fix didn't work for me so I'm starting again.

Intermittent issue with Dynamic Input tool show the error below:

As you can see, I have specified a sheet.

There was a suggestion from previous posts to add the sheet name to the file path in the Dynamic Input tool, this doesn't work for me - just defaults to the normal file-path on closing the dialogue box.

Anyone have a fix?  Or can spot the rookie mistake that I can't??

Thanks

[jie-yan]

The sheet names in my files contain month and year information (e.g."01.2024 data" or "02.2023 Data"). Could you recommend a solution?

[rohit782192]

@LordNeilLord  My Excel has Multiple Sheet.  Sheet 1, Sheet2, Sheet 3... . In Formula Tool I have Mention as Sheet 1 Then it Pick. If in Future the Sheet Changes how the Formula will Change. In Actual the Sheet Name is Different. Is there any Standard Formula to Pick up Directly the First Sheet. Eg First Sheet Name is John and in Formula i will mention as John. But after Few Month i change to Charlie. Without changing in Formula . Then how the workflow will pick the Latest