2 of 2 people found this helpful
Unfortunately this is a known issue when changing datasources even when everything else is the same.
An idea has been logged and voted up by many people.
There are workarounds which require you to select each sheet and allow the data to render before changing the datasource.
There may also be a way of changing this within the XML
Hopefully Tableau will soon come up with a solution to this problem.
Thanks, khalid norat. I guess I just have to continue reformatting until it is resolved.
1 of 1 people found this helpful
This is the idea raised to fixed this issue. Also there are instructions for a workaround here. Hope this helps you in the interim.