Can you include a screenshot of your excel file (or the actual file itself)? I'd like to see how your data looks in Excel coming into Tableau. Based on how Tableau is reading it I think there may be some extra spaces or characters that are throwing it off.
Thanks guys for your valuable inputs. Its kind of strange but I tried connecting to the excel sheet multiple times and eventually everything worked fine suddenly.
Not really sure what made it work after a couple of trials.
Please mark correct and close this thread.
I have quick question on this thread.
I still have this question where I still see the new entries as below under sheets in the Tableau desktop home page even though these sheets/tabs don't exist in the underlined excel sheet. These entries marked in yellow should not be there. Does any one has any ideas please ?
it might be hidden in your excel file. try checking your excel file properly.