it looks peculiar. how many datasources do you have within your workbook and is there a "massive" number of rows and columns in each datasource? and are you sure that all the datasources are pointing at the extracts instead of live?
I have 6 data sources, basically the same Excel file, just 6 different sheets. There are very few rows per sheet, maybe 15-20, but around 40 to 50 columns where each column is an individual KPI we are tracking. I believe it is hitting the extract, as the data doesn't actually update when I change it in the Excel file and hit refresh in Tableau, I have to actually refresh the extract for the data to reflect properly.
For some reason, I simply cannot get this worksheet to stop using temporary extracts.
First, I went to each data source and removed the extract including file.
I clicked the Extract > Remove option
I selected "Remove the extract and delete the extract file."
Made sure there was no more extract file.
After I made sure all data extracts were removed, I created new data extracts, specifying the location as My Tableau Repository > Datasources.
I verify that the extract exists.
But after all that work, I look at the properties in my Data Source and it still says it's using the temporary extract!
For some reason, Tableau created the temporary extract at the exact same time it was creating the actual extract, but the temporary extract is a bit larger in file size.
(The first file starting with 1725qkn1, date modified 1/20/2016 3:57 PM same as Goal1 (KPI_OUTPUT).tde, but a larger file size (305KB vs 295KB)
I'm really at a loss for what's going on and why. I'm still getting the same loading prompts as before, letting me know I should extract the data for a faster start-up experience.
Tableau creates temporary extracts to cache the contents of text and Excel files.
I think all the behavior you are seeing makes sense. The Data Source tab shows the live data from your Excel file in case you change the data source. It has to re-read your Excel file and see if columns have changed data type. That "live" data is managed through a temporary extract.