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

[JerryHuangzy]

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

[Qiu]

@JerryHuangzy 

Just in case, you did save the Excel right?

Test on my end, it shows no issue.

[JerryHuangzy]

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. 

[Qiu]

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

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.