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?