I have been trying to connect to a large Excel spreadsheet in Tableau 8. When I just extract one table from the spreadsheet the data is displayed and I can create charts/graphs in Tableau. The problem is if I try to connect to more than one table within the spreadsheet Tableau acts like it is extracting the data but then at the end when I try to create manipulate it in Tableau the software acts as though it only has the names of the dimensions and measures but no rows of data. So if I drag a dimension to the column field, the working area goes blank. I looked at the source tables within Tableau and there is no data, just the column headers. Has anyone run into this or have ideas as to what is going on? The file is 475 KB.
I am not sure specifically what is going on, but maybe more information would help.
Is this multiple tabs in the same Excel workbook? Are you importing the data or connecting live? If the former, perhaps you should try the latter initially to see if this live connection functions as intended.