Definately best way to do this going forward is to publish the data source and set the schedule to update it automatically. This gives the tableau server control over the location of files etc and you just connect your workbooks to the tableau server data source instead of the local tde...
Not sure if it helps, but twb files are Xml based and the datasources are listed so you may be able to update them in a text editor and publish back to the server? I know this is not a method supported by Tableau, but may help you in the short run.. ALWAYS BACKUP FIRST!
Thanks for the reply on this. Sadly I'm not using Tableau Server right now, just Desktop to refresh the extracts manually.
It just seems odd that I've been updating these .tde files for months, and just recently this temp folder issue arose. Can you think of anything else that may have caused Tableau to stop overwriting the .tde files on the network and go to the temp folder instead?
Many thanks in advance.
It turns out, if you save the workbook that was refreshing the .tde files, it turns the temporary extract in the temp folder back into the .tde file in the original location - thus properly refreshing the extracts as desired.
This slight gap/pause in the refreshing process never occurred before, so if you're seeing similar results, try saving the workbook first and see if the temp file overwrites the actual .tde you're trying to refresh.