You need to put $ signs in your table (sheet) names.Please refer below link where Robin has given good example.Hope this solves your problem.
I tried adding $ signs to my to my table names but still it doesn't work
Are you sure you're using the correct path? Are you able to open the file using the path outside of Tableau?
I'd recommend contacting Tableau support for this issue.