Let's start with basics:
- What Tableau version are you using? 10.0.0?
- Could you locate log.txt (under Documents\My Tableau Repository\Logs) and check if there were any other errors logged at the same time?
- Would it be possible for you to share the sheet?
p.s. this sounds like a support type of material.
I use to Tableau 10.0.0
The problem is when I tried to connect a excel file in google sheets. I can't see the content in the file like other excel file-
Here the file DoubleClick - Google Drive
When you open this file in excel then you can open in tableau, but I need to take the file from google sheets
structure of this excel file doesn't work. Try to remove headers and then it will work
This file is from DoubleClick Digital Marketing is a Adserver.
I can transform to excel in this file, but I want the whole process it will automated
Problems is not with this.
Data Interpreter handles this sheet layout pretty well.
Issue lies with XLSX archive format (yes, you can unzip XLSX file) which Tableau's parser is unable to read properly as it doesn't seem to follow format rules. We'll need to analyze it to see what exactly goes wrong there.