Well after a bit of searching we found the article below, which explains that Tableau stores the meta data for a report (derived calculation, formatting, parameters etc.) within the data source not the report!! Not sure why Tableau chose that approach.
Which means when you change the data source you loose all the original meta data!!
I really hope this is something that changes in later versions.