Can't find the named range in excel when using "Input Data"

Question

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

JerryHuangzy · Answer

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.

Qiu · Answer

@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?

JerryHuangzy · Answer

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.