I built a named range in my excel file, but when I try to input the excel file with my named range in alteryx, it didn't show up.
I want to use West_SC01 but it's not in my list
Thank you fore replying. I do save the excel file. The only thing I concern is the excel is stored in a shared drive. I reopen it several times and the named range I built is indeed there.
@JerryHuangzy
Can not really something else.
I tried net drive as well, it still works.
If this happens to only this particular Excel File, maybe try to delete and recreate the Named Range?
Thank you for your advice. Unfortunately I couldn't do that because that excel is my big data resource that will be renewed automatically everyday. I could only make some tiny revision on that.